Help Table of Contents

Client Help

  1. User Types and Roles
  2. Pro User
    1. Pro Workflow Overview
    2. User Workspace
      1. Welcome Panel
      2. Home Page
        1. Home Menu
          1. System Info
            1. Application Languages
          2. User Defaults
        2. App Toolbox
        3. Quick Start, Tutorials and Guides and Learning Hub
          1. Interactive Tutorials
        4. User Hub
          1. Navigate the User Hub
          2. User Hub Editor
      3. Bulletin Board
        1. Publication Board
        2. Alerts Board
        3. Workflow and Conversation Board
        4. Subscriptions Board
        5. Model Board
      4. Inbox
      5. App Tabs
        1. App Tab Home Menu
        2. App Tab Manager
        3. Quick Open
        4. Job Spooler
          1. Print and Export Summary
        5. Query Benchmarks
        6. Tab Menu
        7. Keyboard Shortcuts
      6. Common App Interface
        1. Color Picker
        2. Clipboard Tools
        3. Saving Content
          1. Assigning Content Access
        4. Print and Export
          1. Printing from Embedded Content
        5. Subscriptions
          1. Configure Subscriptions
        6. Content Scheduling
          1. Define The Schedule
          2. Triggered Schedule Launch
            1. On Demand Schedules
          3. Scheduled Distribution
            1. Bulletin Board Distribution
            2. Email Distribution
            3. Phone Distribution
            4. Webhook Distribution
              1. Channels Dialog
              2. Webhook for Microsoft Teams
              3. Webhook for Slack
    3. Content Management
      1. Accessing Content
      2. Content Manager
        1. Content Explorer
          1. Content Folder Structures
        2. Content Item Mechanics
        3. Favorites
        4. Recents
        5. Most Used
        6. User Recommended
        7. Auto Recommended
        8. Content Search
      3. Content Actions and Tools
        1. Maintenance Mode
        2. Presentation Launcher
        3. Copy-Paste
        4. Cut-Paste or Move
        5. Delete, Purge, and Restore
        6. Run Slide Show
        7. Print Folder
        8. Change Description
        9. Import and Export
        10. Lineage
        11. Open Related Content
        12. Actions Panel
        13. Metadata Panel
        14. Content Tagging
        15. Content Versioning
        16. Copy Direct URL Links
        17. OData Feed
        18. Embed Snippet Generator
        19. Audit Trail (CMS)
        20. Content Roles Panel
          1. Cross Tenancy Options
        21. Data Source Changer
        22. Structure Analyzer
        23. Scheduling and Subscriptions
        24. Alerts Manager
        25. Migration Wizard
      4. Materialized Data Manager
        1. Managing Materialized Data
          1. Data Server Manager
          2. Database Manager
          3. Data Model Manager
      5. Schedule and Subscription Manager
    4. Pro Apps
      1. Model
        1. Data Modeling Concepts
          1. Model Files vs Deployed Models
          2. External Models vs Pyramid Models
          3. Data Flows vs Semantic Models
        2. Smart Modeling
          1. New Smart Model
          2. Smart Modeling Heuristics
          3. Manage Smart Models
            1. Open And Edit Smart Models
            2. Save Smart Models
            3. Secure Smart Models
            4. Rerun Smart Models
        3. Model Lite
          1. New Lite Model
            1. Target
            2. Data
            3. Tables
            4. Columns
            5. Hierarchies
            6. Finish and Build
            7. Model Lite Heuristics
          2. Manage Lite Models
            1. Open Edit Lite Models
            2. Save Lite Models
            3. Rerun Lite Models
        4. Direct Model
          1. Servers
          2. Schema Display
          3. Relationships and Joins
          4. Managing Direct Models
            1. Save a Direct Model
            2. Open and Edit a Direct Model
            3. Process a Direct Model
            4. Rerun Direct Models
        5. Model Pro
          1. Model Pro Examples
          2. Master Flow
            1. Master Flow Interface
            2. General Nodes
              1. Data Flow
              2. SQL Script
              3. Data Model
              4. Set Variable
              5. Rest APIs
              6. Pyramid Event
              7. Command Line Support
              8. On Demand Schedules
              9. Wait
            3. Looping Steps
              1. For Loop
              2. For Each Loop
              3. While Loop
            4. Conditional
              1. Conditional Node
              2. Switch Statement
            5. Messaging
              1. Email
              2. SMS
            6. Master Flow Validation
          3. Data Flow
            1. Data Flow Interface
              1. Data Flow Ribbon
              2. Properties
              3. Node Selection
              4. Datasource Preview
                1. Column Statistics
              5. Variables
                1. Variables Panel
                2. SQL Variables Vs Static Variables
                3. Incremental Loading
                4. Inject Variables
              6. Workspace Layout
              7. Split Nodes
            2. Sources
              1. Data Sources and Targets
              2. Direct Query vs Ingested Data
              3. Use Existing Semantic Model
              4. File Sources
                1. Pyramid Reports
                2. Access
                3. Excel
                4. Google Sheets
                5. Provide a JSON File Source
                6. Multi Files
                7. SAS Data Set Source
                8. Text File Sources
                9. XML File Source
              5. Relational Sources
                1. Pyramid In Memory Database
                2. SAP HANA Datasource
              6. BigData Sources
                1. Adding Big Query as a Data Source
                2. MongoDb Datasource
              7. Cloud Sources
                1. Amazon S3
                2. Azure Blob
                3. Box
                4. Facebook Data Source
                5. Google Analytics (GA4)
                6. Google Drive
                7. RSS
                8. SalesForce
                9. SharePoint
                10. SFTP (SSH) and FTP
                11. X (Twitter) Data Source
              8. Other Sources
                1. ODBC
                2. ODBC Direct
                3. OData Datasource
                4. Date Range Source
                5. Scripted Sources
                  1. Python Source
                  2. R Source
            3. Data Flow Targets
              1. Target Tables
              2. Pyramid IMDB
              3. File Targets
                1. Amazon S3
                2. Azure Blob
                3. Box
                4. CSV
                5. Excel
                6. Google Drive
                7. Parquet
                8. SFTP (SSH) and FTP
                9. Folder Path Expression
              4. Relational Targets
                1. Custom Target Schema
                2. Execute a Script
              5. Big Data and Unstructured Targets
            4. Select
              1. Query
              2. Table
              3. Multi Tables
              4. Bottom N
              5. Top N
            5. Preparation
              1. Add Date/ Time
              2. Add Sequence
              3. Date Range
              4. Distinct
              5. Filter
              6. GeoCode
              7. Materialized Masking
              8. Modify Case
              9. Pivot
              10. Random Number
              11. Remove Duplicates
              12. Sort
              13. Summarize
              14. Time Intelligence
              15. Unpivot
            6. Gen-AI
              1. LLM Translate
              2. LLM Sentiment
              3. LLM General
            7. Column Operations
              1. Calculated Columns
                1. Custom Column PQL Editor
              2. Combined Columns
              3. Convert Columns
              4. JSON Extract
              5. Rename Columns
              6. Reorder Columns
              7. Split Columns
              8. Add Date Unit
              9. Date Difference
              10. Replace
              11. String Left
              12. String Right
              13. Substring
              14. Trim
              15. Aggregate FX
              16. Math FX
              17. Trig FX
            8. Joins
              1. Merge Join
              2. Union Join
            9. Machine Learning
              1. Machine Learning Functions
                1. Decision Tree
                2. Naïve Bayes
                3. Regression Trees
              2. Tensor Flow
              3. Machine Learning Nodes
              4. Machine Learning Examples
            10. Scripting
              1. Scripting Mechanics
                1. Scripting Inputs and Outputs
                  1. Data Frame Support
                2. Learn and Predict Scripts
                  1. Python Learn and Predict Examples
                3. Save Machine Learning Models
                4. Generate Your Script
                  1. Explain Script
                5. Marketplace
                  1. Marketplace Scripts
                    1. Sentiment Analysis Example
                    2. Basket Analysis Example
                6. Shared Scripts
                7. Virtual Scripting Environments
              2. Python Scripting
              3. R Scripting
            11. Validate Data Flow
            12. Model Transfer Cleanup
          4. Data Modeling
            1. Model Ribbons
              1. Configuration Ribbon
              2. Tables Ribbon
              3. Columns Ribbon
              4. Hierarchy Ribbon
            2. Configuration
              1. MS Tabular Models
              2. Auto Indexing
              3. Query Caching
            3. Tables Panel
              1. Relationships and Tables
              2. Relationship Table Editor
              3. Sync Settings
              4. Connector Types
              5. Context Menus and Properties
              6. Auto Table Update
              7. Automatic Column Handling
              8. Joins
                1. Heuristics
                2. Join Keys
                3. Bidirectional Joins
                4. Join Validation
              9. Columns
                1. Column Visibility
                2. Column Description
                3. Data Catalog
                4. Column Folders
                5. Column Categories
                6. Dynamic Data Masking
              10. Measures
                1. Measure Types
                  1. Cumulative Measure
                  2. Semi Additive Measures
                2. Measure Formats
                3. Measure Folders
                4. Measure Descriptions
                5. Multi-Measures
                6. Measure Editor
                7. Units and Currency
              11. Primary Keys and Indexing
              12. Special Tables and Columns
                1. Aggregate Tables
                2. Security Tables and Columns
                3. Distribution Tables and Columns
                4. Add Custom Query Table
            4. Columns
              1. Column Configuration
                1. Configure Custom Maps
              2. Multi-Measures Panel
              3. Column Sorting
              4. Virtual Column Calculations
                1. Calculated Columns Panels
                2. Calculated Columns Settings
                3. Calculated Column Walkthrough
            5. Hierarchy Panel
              1. Hierarchy Panel Mechanics
                1. Hierarchy Metadata
                2. Ragged Hierarchies
                3. Parent Child Hierarchies
                  1. Build Parent Child Hierarchies
                  2. Parent Child Hierarchy Examples
            6. Translations Panel
              1. Translations Attribute
          5. Model Processing
            1. Quick Discovery
            2. Schedule a Data Model
            3. Node Execution Status
            4. Progress Panel
          6. Security
            1. Security Settings
            2. Data Source Management
          7. Model Management
            1. Open and Edit a Model
            2. Save Models
            3. Printing and Documentation
      2. Discover
        1. Viewing Discover Content
        2. Natural Language Querying
          1. Accessing NLQ in Discover
          2. NLQ Chatbot
          3. Example: Build a Visual using the Chatbot
          4. Writing NLQ Questions
            1. NLQ: Advanced Intelligence
            2. NLQ: Visualizations
          5. Managing NLQ Discoveries
        3. Smart Discover
          1. Access Smart Discover
          2. Smart Discover Workspace
            1. Item Selection Bar
            2. Visualization Picker
              1. Smart Visualization Mechanics
            3. Design Panel
          3. Build Smart Discoveries
            1. Values
            2. Dimensions
              1. Custom Selections
              2. Sort and Filter Hierarchies
              3. Working with Dates
                1. Date-Time Calculations
                2. Date Parts
            3. Data Filters
            4. Visualizations
              1. Quick Styles
                1. Quick Styles
                2. Quick Styles for Grids
                3. Quick Styles for Cartesian Charts
                4. Quick Styles for Segment Charts
                5. Quick Styles for Plotted Charts
                6. Quick Styles for Maps
          4. Manage Smart Discoveries
            1. Save and Share
        4. Discover Lite
          1. Access Discover Lite
          2. Discover Lite Workspace
            1. Drop Zones
            2. Discover Lite Ribbon
              1. Axis Options
              2. Data Labels
              3. Data Points
              4. Grid Lines
            3. Model Metadata and Trees
          3. Build Lite Discoveries
            1. Drop Zones
            2. Visualizations
              1. Quick Styles
            3. Dynamic Interactions
            4. Quick Calculations
            5. Context Calculations
          4. Manage Lite Discoveries
          5. Conversations
        5. Discover Pro
          1. Access Discover Pro
            1. Pyramid Models
              1. Direct Model on a Database
              2. Direct Model with SQL
            2. Microsoft Models
            3. SAP Models
              1. SAP HANA Views
              2. SAP BW Models
          2. Discover Pro Workspace
            1. Discover Pro Ribbons
              1. Panel Layout
              2. New Report
              3. User Defaults (Discover)
            2. Panels
              1. Drop Zones Panel
              2. Data Model Trees
                1. Dimensions and Hierarchies
                  1. Hierarchy Types
                  2. Hierarchy Properties
                  3. Measure Group Filtering
                  4. Alternative Captions
                    1. SAP BW Technical Names
                2. Elements
                3. Measures
                  1. Measure Properties
                4. Refresh Metadata
                5. Languages
              3. Visualizations
              4. Content Panel
              5. Query Metadata Panel
              6. Performance Dialog
              7. Smart Insights
          3. Navigating and Querying Data
            1. Building Queries
              1. Using Data Model Metadata
                1. Using the Hierarchies Tree
                  1. Using Attribute Hierarchies
                  2. Using Regular Hierarchies
                  3. Using Drill Path Hierarchies
                  4. Using Parent-Child Hierarchies
                  5. Using Geospatial Hierarchies
                  6. Using Date-Time Hierarchies
                  7. Using Image URL Hierarchies
                  8. Using URL Hierarchies
                  9. Using Hidden Hierarchy Properties
                2. Using the Elements Tree
                  1. Elements Tree Context Menu
                  2. List Builder
                  3. Members Search
                3. Using the Measures Tree
              2. Drop Zones
                1. Values Drop Zone
                  1. Colorize Values
                  2. Shapify Values
                2. Column and Row Drop Zone
                3. Categories Drop Zone
                4. Trellis Drop Zones
                5. Color Drop Zone
                6. Shape Drop Zone
                7. Size Drop Zone
                8. Labels Drop Zone
                9. Tooltip Drop Zone
                10. Indicator and Status Drop Zones
                11. Motion Drop Zone
                12. Details Drop Zone
                13. Map Location / Shape Drop Zone
                14. Filters Drop Zone
                  1. Calendar Slicers
                    1. Calendar Pickers
                    2. Calendar Slicer Settings
                  2. Tree Slicer
                  3. Slicer Limits
                  4. Cascading Slicers
                    1. Manually Building Cascading Slicers
                  5. Slicer Settings
                  6. Slicer Styles
                  7. Slicer Formatting
                  8. Background Filters
                  9. Making Slice Selections
                  10. Bookmarks
                  11. Pre-Query Slicers
                    1. Manage Pre-Query Bookmarks
                15. More Drop Zone Options
                  1. Copy or Move
              3. Building Visualizations
                1. Raw Results
                2. Grids
                  1. Matrix Grid
                  2. Tabular Grid
                3. Cartesian Charts
                  1. Column Chart
                  2. Stacked Column Chart
                  3. Stacked 100 Column Chart
                  4. Marimekko Chart
                  5. Bar Chart
                  6. Stacked Bar Chart
                  7. Stacked 100 Bar Chart
                  8. Tornado Chart
                  9. Multi-Measure Charts
                  10. Combo Charts
                  11. Line Chart
                  12. Point Charts
                  13. Lollipop Charts
                  14. Area Chart
                  15. Stream Chart
                4. IBCS-Like Charts
                  1. IBCS-Like Area Chart
                  2. IBCS-Like Column Chart
                  3. IBCS-Like Line Chart
                  4. IBCS-Like Lollipop Chart
                5. Segment Charts
                  1. Pie Chart
                  2. Doughnut Chart
                  3. Pyramid Chart
                  4. Funnel Chart
                  5. Multi-Measure Segment Charts
                6. Radar Charts
                7. Plotted Charts
                  1. Scatter Chart
                  2. Bubble Chart
                  3. Scatter Line Chart
                8. Advanced Charts
                  1. Tree Map Chart
                  2. Hierarchical Tree Map Chart
                  3. Circle Packing Chart
                  4. Hierarchical Circle Packing Chart
                  5. Sankey Chart
                  6. Word Cloud
                  7. Sunburst Chart
                  8. Icicle Chart
                9. KPI Charts
                  1. Gauges
                  2. Bullet Chart
                10. Maps
                  1. Bubble Maps
                  2. Shape Maps
                    1. Custom Maps
                  3. Geo Heat Map
                  4. Map Quick Styles
                  5. Geo-Boundary
                11. Other Charts
                  1. Candlestick Chart
                  2. Box and Whisker Chart
                  3. Waterfall Chart
                  4. IBCS-Like Waterfall Chart
                12. Custom Visuals
                13. Conditional Formatting
                  1. Conditional Formatting Context Menu
                  2. Conditional Formatting via Drop Zones
                    1. Value Driven Colors
                    2. Conditional Color Examples
                    3. Text Indicator
                  3. Conditional Formatting Dialog
                  4. Conditional Formatting Logic
              4. Running Queries
                1. Query and Report Reset
            2. Changing and Manipulating Queries
              1. Query Interactions
                1. Drill-Up and Drill-Down
                2. Dice, Add, Swap, and Remove
                3. Expand and Collapse
                4. Element and Data Point Selection
                  1. Focus and Descendants
                5. Fill the Blanks
                6. Quick Sort
                  1. Set Element Order
                7. Quick Filter
                8. Pivot
                9. Quick Totals
                10. Explain
                  1. Explain explained
                  2. Explain the Difference
                11. Extended Query Interactions
                12. Interactive Selections
              2. Query Functions
                1. Show or Hide Empties
                2. Totals
                3. Sorting
                4. Value Filtering
                5. Eliminations
                6. N-of-N
                7. Hide Query Info
              3. Advanced Query Functions
                1. Forecasting
                  1. Basic Forecasting
                  2. Advanced Forecasting
                    1. Custom Forecast Scripts
                2. Regression Functions
                3. Statistics
                4. Pareto
                5. Clustering
                6. Outliers
                7. Fill Blanks
            3. Calculations in Discover
              1. Quick Calculations
                1. Group Calculations
                2. Quick Formulas
                3. Quick Lists
                  1. Quick Variable Lists
                4. Quick Parameters
                  1. Quick Static Parameters
                5. Quick KPIs
                6. Managing Quick Calculations
                  1. Saving and Sharing Calculations
                  2. Internal Parameters
              2. Context Calculations
                1. Difference Context Functions
                2. Cumulative Context Functions
                3. Statistical Context Functions
                4. Advanced Analytic Context Functions
                5. Managing Context Calculations
                6. Customizing Context Calculations
              3. Custom Columns
                1. Aggregations
                2. Categorization
                3. Date Parts
                4. String Functions
                5. AI Driven Columns
                6. Managing Custom Columns
              4. Other Calculation Tools
                1. Time Calculation Wizard
                  1. To Date
                  2. Last n Periods
                  3. Periods
                    1. Full Period
                    2. Period On Period
                    3. Parallel Day
                    4. Parallel Period
                2. Variable Lists
            4. Query Options
              1. Query Settings
              2. Choose Language
              3. Model Colors and Formats
          4. Formatting and Design
            1. Copy Styles
            2. Reset Formatting
            3. Report Design
              1. Themes
              2. Report Title
              3. Background Color
              4. Notes
                1. AutoML Explanations
              5. Discover Runtime Settings
              6. Tooltip
              7. Auto-Colorize
              8. Member Color Lock
            4. Visualization Design
              1. Quick Styles
              2. IBCS-Like Charts
                1. IBCS-Like Area Chart
                2. IBCS-Like Column Chart
                3. IBCS-Like Line Chart
                4. IBCS-Like Lollipop Chart
                5. IBCS-Like Waterfall Chart
              3. Formatting Panel
                1. Grid Formatting
                  1. Matrix Grid
                    1. Alignment
                    2. Alternate Rows
                    3. Column Size
                    4. Expand Icons
                    5. Grid Borders
                    6. Grid Font
                    7. Grid Font Alignment
                    8. Grid Padding
                    9. Row Area Size
                    10. Total Formatting
                  2. Data
                  3. Columns and Rows
                  4. Contextual Formatting
                  5. Clear Custom Formatting
                2. Cartesian Chart Formatting
                  1. Cartesian Charts
                  2. Chart Padding
                  3. Plot Area
                3. Segment Chart Formatting
                  1. Explode
                4. Radar Chart Formatting
                  1. Radar Line Chart
                5. Plotted Chart Formatting
                  1. Plotted Charts
                  2. Axis Position
                  3. Reference Line
                6. KPI Chart Formatting
                  1. Gauge Formatting
                    1. Gauge Labels
                      1. Gauge Value
                    2. Gauge Shape
                    3. Gauge Shadow
                    4. Auto Fit Labels
                    5. Gauge Scale
                  2. Bullet Chart Formatting
                    1. Bullet Chart Indicators
                    2. Bullet Chart Scale
                7. Advanced Chart Formatting
                  1. Circle Packing Chart
                  2. Sankey Chart
                  3. Sunburst Chart
                  4. Tree Map Chart
                  5. Waterfall Chart Formatting
                  6. Word Cloud Chart
                8. Map Formatting
                  1. Auto Center Map
                  2. Bubble Map Formatting
                  3. Shape Map Formatting
                  4. Geo Heat Map Formatting
                  5. Map Colors
                  6. Map Default Labels
                  7. Map Labels
                  8. Geospatial Defaults
                  9. Scale Control
                  10. Zoom Control
                9. Custom Visuals
              4. Common Design Capabilities
                1. Axes
                2. Color
                3. Data Labels
                  1. Data Label Optimization
                4. Legends
                  1. Combined Color Shape Legend
                  2. Legend Formatting
                  3. Series Editing
                5. Line Style
                6. Multi Chart Title
                7. Opacity
                8. Scale to Fit
                9. Shapes and Data Points
                10. Trellis Axes
                11. Visual Optimization
              5. Design Tools from the Ribbons
                1. Quick Styles
                  1. Grid Quick Styles
                  2. Cartesian Chart Quick Styles
                  3. Segment Chart Quick Styles
                  4. Plotted Chart Quick Styles
                  5. Map Quick Styles
                2. Axis Options
                3. Custom Reference Line
                4. Chart Border Width
                5. Mini Map
                6. Range Slider
                7. Custom Trellising
                8. Data Points
                9. Font Size
                10. Font Color
                11. Image Size
                12. Motion
                13. Readability
                14. Row Limit
                15. Show Data Grid
          5. Extended Functionality
            1. Discovery Actions
              1. Action Panel
                1. Jump To URL
                2. JavaScript Actions
                3. Tooltip Actions
                4. Action Library (PQL)
              2. Cube Actions
              3. Manage Actions
            2. Alerts Builder
              1. Advanced Alerts
            3. Workflows and Conversations in Discover
              1. Start a Conversation
              2. Managing Workflows and Conversations
            4. SAP Parameters for BW and HANA
            5. Data Catalog Viewer
          6. Manage Discoveries
            1. Save and Share Discoveries
            2. Printing in Discover
            3. Discovery Subscriptions
            4. Open and Edit Discoveries
            5. User Settings
        6. Auto Discover
          1. Auto Discover Explained
      3. Formulate
        1. Common Formulate Workspace
          1. Formulate Panels
          2. Model Metadata in Formulate
          3. Script Editor
          4. AI Generated Script
          5. Quick Discovery
          6. Quick Logic
          7. Functional Selection
          8. Internal Parameters
        2. Formulas (Members and Measures)
          1. Formula Ribbon
            1. Marketplace
            2. Multi-lingual Formulas
            3. Choose Language
          2. Formula Properties
            1. MDX Properties
            2. Formatting by Cell in MDX
            3. Dynamic Captions
              1. Walkthrough: Build Dynamic Captions
          3. Preview Panels
          4. Formula Script Editor
          5. Formula Examples
            1. Walkthrough: Percentage Markup Formula
            2. Walkthrough: Yearly Sales Variance
            3. Walkthrough: Custom Formula in Script Mode
        3. Lists (Sets)
          1. List Ribbon
            1. Move to Start or End
          2. List Properties
          3. List Script Editor
          4. List Actions
            1. Add
              1. Standard List
              2. Measure List
              3. Range List
              4. Full Month
              5. Full Quarter
              6. Full Week
              7. Full Year
              8. Month to Date
              9. Parallel Period
              10. Quarter To Date
              11. Week To Date
              12. Year To Date
            2. Derive
              1. Except/ Remove
              2. Intersect
              3. Set Intersect
              4. Union
            3. Filter
              1. Bottom Count
              2. Bottom Percent
              3. Bottom Sum
              4. Contains
              5. Ends With
              6. Equals
              7. Filter
              8. First
              9. Last
              10. Starts With
              11. Top Count
              12. Top Percent
              13. Top Sum
            4. Sort
              1. Natural Order
              2. Order by Label
              3. Order by Selection
              4. Order by Value
            5. Fork
              1. If
              2. Switch
          5. List Examples
            1. Build a List
            2. List in Script Mode
        4. KPIs
          1. KPI Ribbons
          2. Building a KPI
            1. KPI Dynamic Bands
            2. KPI Script Editor
          3. Using KPIs
            1. Gauge Color Types
            2. Gauge Indicator Types
          4. Walkthroughs: KPIs
        5. Custom Columns
          1. Custom Column Ribbon
          2. Custom Column Properties
            1. Custom Column Settings
            2. Custom Column Measures
            3. Creating Measures
          3. Custom Column Panels
            1. Preview Panel
            2. Model Attributes Panel
          4. Custom Column Examples
            1. Walkthrough: Create New Attribute
            2. Walkthrough: Create New Measure
            3. Walkthrough: Custom Column in Script Mode
        6. Parameters
          1. Parameter Designer
          2. Dynamic List Parameters
          3. Parameter Types
            1. Discrete Parameters
            2. Continuous Parameters
            3. Free Form Parameters
        7. Scripting
          1. Shared Scripting
        8. Custom Visualizations
          1. Custom Visual Ribbon
      4. Present
        1. Smart Present
        2. Present Lite
          1. Access Present Lite
          2. Present Lite Workspace
            1. Present Lite Actions Menu
            2. Present Lite Design
            3. Present Lite Panels
          3. Build Lite Presentations
            1. Add Content
            2. Miniature Visualizations
            3. New Slicer
            4. Dynamic Text Fields
            5. Import Images
            6. Static Text
            7. Shapes
            8. Interactions
          4. Run Lite Presentations
            1. Slicers
            2. Cross-Filtering and Highlighting
          5. Manage Lite Presentations
        3. Present Pro
          1. Presentation Overview
            1. Present Ribbons
            2. Present Workspace
            3. Slides and Sections
            4. Context Menus
            5. Building Presentations
              1. Build a Presentation
              2. Build a Storyboard with the Chatbot
              3. Page Layout and Design
              4. Grouping
          2. Presentation Design
            1. Theme, Device, and Layout
              1. Tooltip Presentations
              2. Slide Formatting and Layout
              3. Auto Layout
              4. Visual Formatting
                1. Format Multiple Items
                2. Formatting Panel
                  1. Panel Settings
                3. Unlink Content
                4. Range Slider
                5. Scaling and Auto Fit
                6. Auto Fit Labels
                7. Miniature Visualizations
                8. Presentation and Publication Legends
                9. Layout Containers
                  1. Matrix Table Layout
                  2. Scrollable Layout
                  3. Mini-Tab Layout
                    1. Conditional Display
              5. Panels
                1. Show Panels
                2. Panel Styles
                3. Panel Tools
              6. Grid Sizing
            2. Master Page Templates
              1. Navigation Options
              2. Web Page Assets
            3. Refresh Snapshots
            4. AI Image Generator
          3. Presentation Analytics
            1. Presentation Slicers
              1. New Slicer
              2. Advanced Slicer Wizard
              3. Slicer Settings
              4. Slicer Formats
              5. Measure Slicers
              6. Hidden Slicers
              7. Disable Slicers
              8. Detach Slicer
              9. Duplicate Slicers
              10. Edit Slicers
              11. Delete Slicers
            2. Interactions and Filtering
              1. Interaction Manager
              2. Auto Interact
              3. Show and Edit Interactions
              4. Remove Interactions
              5. Interaction Picker
              6. Integrate Slicers with Dynamic Images
              7. Cross-Visual Interactions
                1. Cross-Filtering
                2. Cross Filtering Slicers
                3. Cross Highlighting Slicers
              8. Present Targets
              9. Range Slicers in Present
              10. Cross Model Mapping
            3. Assets
              1. Add Dynamic Text
                1. Dynamic Text Editor
                2. Auto Translate
                3. Text Formatting
                4. Dynamic Place Holder
                5. Dynamic Tooltips
                6. Empty Strings
                7. Graphic Text
                8. Add Text Fields
                  1. AI Slide Insights
                  2. Model Processed Date
              2. Dynamic Jump Buttons
                1. Jump to Slide
                2. Jump to Content Item
                3. Jump to URL
                4. Execute JavaScript
                5. Publication Print
              3. Dynamic Web Panels
              4. Dynamic Clipboard Tools
          4. Presentation Runtime
            1. Present Runtime Settings
            2. Presentation Menu
            3. Explanations in Present
            4. OData Link
            5. Bookmarks
              1. Manage Bookmarks
            6. Pre-Query Slicers (Present)
            7. Presentation Actions
              1. Slicer Actions
              2. Tooltip Actions
              3. Tooltip Presentations
            8. Presentation Timer
            9. Alerts
            10. Workflows in Present
            11. Analyze Further
            12. Printing in Present
            13. NLQ Chatbot (Present)
              1. Explore a Storyboard using Chatbot
            14. Smart Insights
            15. Presentation Subscriptions
      5. Publish
        1. Smart Publish
        2. Publish Lite
          1. Access Publish Lite
          2. Publish Lite Workspaces
            1. Publish Lite Ribbon
            2. Publish Lite Toolbox
            3. Publish Lite Pages
            4. Publish Lite Canvas
          3. Build Lite Publications
            1. Add Content
            2. Add Slicers
            3. Add Static Text
            4. Dynamic Text
              1. Dynamic Text Fields
              2. Dynamic Placeholders
            5. Table of Contents
            6. Add Static Graphics
            7. Context Menus
            8. Interaction Manager
            9. Themes
            10. Cover Pages
            11. Align and Distribute
            12. Grouping
          4. Manage Lite Publications
            1. Save Lite Publications
            2. Print and Export
            3. Subscriptions
            4. Link Back to Live Content
        3. Publish Pro
          1. Publication Overview
            1. Building Publications
              1. Publication Workspace
              2. Publish Ribbons
              3. Context Menus
              4. Text and Shapes
              5. Build a Publication
              6. Build a Publication using the Chatbot
          2. Publication Design
            1. AI Image Generator
            2. Refresh Snapshots
            3. Page Sizes and Orientation
            4. Content Layout Tools
            5. Publication Templates
            6. Auto Layout Publish
            7. Content Captioning
            8. Publication Legends
            9. Text Fields
            10. Flow Visual
            11. Grid Sizing
            12. Unlink Content
            13. Formatting Panel
              1. Panel Settings
            14. Show Warnings
            15. Layout Containers
              1. Matrix Table Layout
              2. Conditional Display
          3. Publication Analytics
            1. Publication Slicers and Interactions
              1. New Quick Slicer
              2. Advanced Slicer Wizard
              3. Page Repeater
              4. Interaction Manager
              5. Range Slicers in Publish
              6. Cross Model Mapping
            2. Add Dynamic Text to Publications
              1. Dynamic Text Editor
              2. Text Formatting
              3. Empty Strings
              4. Dynamic Place Holder
          4. Publishing and Distribution
            1. Printing in Publish
            2. Subscribe to Publication
            3. Scheduled Publishing
            4. PDF Bookmarks
            5. Link-Back
            6. Distribution
              1. Bulletin Board Distribution
              2. Email Distribution
              3. Static Distribution List
              4. Dynamic Distribution
                1. Distribution via File Mapping
                  1. Walkthrough: File Mapping
                2. Distribution via Data Mapping
                  1. Walkthrough: Data Mapping
              5. Triggers
            7. Access Scheduled Publications
      6. Illustrate
        1. Illustrate Ribbons
        2. Dynamic Images
          1. Dynamic Graphic Properties
          2. Import Images
          3. Build Dynamic Images
        3. Dynamic Text
          1. Dynamic Text Properties
          2. Build Dynamic Text
          3. Empty Strings
          4. Graphic Text
        4. Dynamic Tooltips
        5. Dynamic Functions
        6. Use Dynamic Images and Texts
      7. Tabulate
        1. Tabulate Pro
          1. Accessing Tabulate
            1. Viewing Tabulate Content
            2. How to Enable/Disable Tabulate
          2. Tabulate Workspace
            1. Tabulate Canvas
              1. Zoom in or out of a sheet
            2. Tabulate Ribbons
            3. Tabulate Toolbox
            4. Tabulate Status Bar
            5. Tabulate Sheets
            6. Hiding and Showing Sheets
          3. Working with Spreadsheets
            1. Data Entry and Cells
              1. Rows and Columns
              2. Resizing Rows and Columns
              3. Hide and Show Rows and Columns
              4. Freeze Panes
              5. Clipboard
              6. Named Ranges
              7. Working with Formulas
                1. More Formula Details
                2. Formula Bar
                3. Formula Wizard
            2. Formatting
              1. Gridlines
              2. Headers
              3. Themes
              4. Cell Formatting
              5. Number Formatting
              6. Tables
              7. Filtering and Sorting
              8. Conditional Formats in Tabulate
                1. Applying Conditional Formats
            3. Using Live Data
              1. Importing Data and Content
                1. Smart Report
                2. Discover Lite
                3. Importing Existing Spreadsheets
              2. Slicers
                1. Attaching Slicers
                2. Pre-Query Slicers (Tabulate)
              3. Parameters
                1. Attaching Parameters
                2. Editing Parameters
                3. Internal Parameters
              4. Managing Data Sources
                1. Cross Model Mapping
              5. Blending Queries
          4. Creating Tabulate Visuals
            1. Drop Zones
            2. Formatting Panels
            3. Panel Layout
          5. Embedding in Present and Publish
          6. Managing Tabulations
            1. Saving Tabulations
            2. Printing and Exporting
            3. Mobile Access
          7. Solve Overview
            1. Optimization Explained
            2. Using Solve
            3. Solve Panel
              1. Solve Advanced Settings
            4. Complete Solve Example
        2. Tabulate Lite
          1. Accessing Tabulate Lite
            1. Viewing Tabulate Content
            2. How to Enable/Disable Tabulate
          2. Tabulate Lite Workspace
            1. Tabulate Lite Canvas
              1. Zoom in or out of a sheet
            2. Tabulate Lite Ribbons
            3. Tabulate Lite Toolbox
            4. Slicers
            5. Tabulate Status Bar
            6. Tabulate Sheets
            7. Hiding and Showing Sheets
          3. Working with Spreadsheets
            1. Data Entry and Cells
              1. Rows and Columns
              2. Resizing Rows and Columns
              3. Hide and Show Rows and Columns
              4. Freeze Panes
              5. Clipboard
              6. Named Ranges
              7. Working with Formulas
                1. More Formula Details
                2. Formula Bar
                3. Formula Wizard
            2. Formatting
              1. Themes
              2. Cell Formatting
              3. Number Formatting
              4. Tables
              5. Filtering and Sorting
              6. Conditional Formats in Tabulate
                1. Applying Conditional Formats
            3. Using Live Data
              1. Importing Data and Content
                1. Smart Report
                2. Discover Lite
                3. Importing Existing Spreadsheets
              2. Blending Queries
          4. Creating Tabulate Visuals
            1. Drop Zones
            2. Formatting Panels
            3. Panel Layout
          5. Embedding in Present and Publish
          6. Managing Tabulations
            1. Saving Tabulations
            2. Printing and Exporting
            3. Mobile Access
  3. Analyst User
    1. User Workspace
      1. Welcome Panel
      2. Home Page
        1. Home Menu
          1. System Info
            1. Application Languages
          2. User Defaults
        2. App Toolbox
        3. Quick Start, Tutorials and Guides and Learning Hub
          1. Interactive Tutorials
        4. User Hub
          1. Navigate the User Hub
          2. User Hub Editor
      3. Bulletin Board
        1. Publication Board
        2. Alerts Board
        3. Workflow and Conversation Board
        4. Subscriptions Board
        5. Model Board
      4. Inbox
      5. App Tabs
        1. App Tab Home Menu
        2. App Tab Manager
        3. Quick Open
        4. Job Spooler
          1. Print and Export Summary
        5. Query Benchmarks
        6. Tab Menu
        7. Keyboard Shortcuts
      6. Common App Interface
        1. Color Picker
        2. Clipboard Tools
        3. Saving Content
          1. Assigning Content Access
        4. Print and Export
          1. Printing from Embedded Content
        5. Subscriptions
          1. Configure Subscriptions
        6. Content Scheduling
          1. Define The Schedule
          2. Triggered Schedule Launch
            1. On Demand Schedules
          3. Scheduled Distribution
            1. Bulletin Board Distribution
            2. Email Distribution
            3. Phone Distribution
            4. Webhook Distribution
              1. Channels Dialog
              2. Webhook for Microsoft Teams
              3. Webhook for Slack
    2. Content Management
      1. Accessing Content
      2. Content Manager
        1. Content Explorer
          1. Content Folder Structures
        2. Content Item Mechanics
        3. Favorites
        4. Recents
        5. Most Used
        6. User Recommended
        7. Auto Recommended
        8. Content Search
      3. Content Actions and Tools
        1. Maintenance Mode
        2. Presentation Launcher
        3. Copy-Paste
        4. Cut-Paste or Move
        5. Delete, Purge, and Restore
        6. Run Slide Show
        7. Print Folder
        8. Change Description
        9. Import and Export
        10. Lineage
        11. Open Related Content
        12. Actions Panel
        13. Metadata Panel
        14. Content Tagging
        15. Content Versioning
        16. Copy Direct URL Links
        17. OData Feed
        18. Embed Snippet Generator
        19. Audit Trail (CMS)
        20. Content Roles Panel
          1. Cross Tenancy Options
        21. Data Source Changer
        22. Structure Analyzer
        23. Scheduling and Subscriptions
        24. Alerts Manager
        25. Migration Wizard
      4. Materialized Data Manager
        1. Managing Materialized Data
          1. Data Server Manager
          2. Database Manager
          3. Data Model Manager
      5. Schedule and Subscription Manager
    3. Lite Apps
      1. Discover Lite
        1. Access Discover Lite
        2. Discover Lite Workspace
          1. Drop Zones
          2. Discover Lite Ribbon
            1. Axis Options
            2. Data Labels
            3. Data Points
            4. Grid Lines
          3. Model Metadata and Trees
        3. Build Lite Discoveries
          1. Drop Zones
          2. Visualizations
            1. Quick Styles
          3. Dynamic Interactions
          4. Quick Calculations
          5. Context Calculations
        4. Manage Lite Discoveries
        5. Conversations
      2. Present Lite
        1. Access Present Lite
        2. Present Lite Workspace
          1. Present Lite Actions Menu
          2. Present Lite Design
          3. Present Lite Panels
        3. Build Lite Presentations
          1. Add Content
          2. Miniature Visualizations
          3. New Slicer
          4. Dynamic Text Fields
          5. Import Images
          6. Static Text
          7. Shapes
          8. Interactions
        4. Run Lite Presentations
          1. Slicers
          2. Cross-Filtering and Highlighting
        5. Manage Lite Presentations
      3. Publish Lite
        1. Access Publish Lite
        2. Publish Lite Workspaces
          1. Publish Lite Ribbon
          2. Publish Lite Toolbox
          3. Publish Lite Pages
          4. Publish Lite Canvas
        3. Build Lite Publications
          1. Add Content
          2. Add Slicers
          3. Add Static Text
          4. Dynamic Text
            1. Dynamic Text Fields
            2. Dynamic Placeholders
          5. Table of Contents
          6. Add Static Graphics
          7. Context Menus
          8. Interaction Manager
          9. Themes
          10. Cover Pages
          11. Align and Distribute
          12. Grouping
        4. Manage Lite Publications
          1. Save Lite Publications
          2. Print and Export
          3. Subscriptions
          4. Link Back to Live Content
      4. Tabulate Lite
        1. Accessing Tabulate Lite
          1. Viewing Tabulate Content
          2. How to Enable/Disable Tabulate
        2. Tabulate Lite Workspace
          1. Tabulate Lite Canvas
            1. Zoom in or out of a sheet
          2. Tabulate Lite Ribbons
          3. Tabulate Lite Toolbox
          4. Slicers
          5. Tabulate Status Bar
          6. Tabulate Sheets
          7. Hiding and Showing Sheets
        3. Working with Spreadsheets
          1. Data Entry and Cells
            1. Rows and Columns
            2. Resizing Rows and Columns
            3. Hide and Show Rows and Columns
            4. Freeze Panes
            5. Clipboard
            6. Named Ranges
            7. Working with Formulas
              1. More Formula Details
              2. Formula Bar
              3. Formula Wizard
          2. Formatting
            1. Themes
            2. Cell Formatting
            3. Number Formatting
            4. Tables
            5. Filtering and Sorting
            6. Conditional Formats in Tabulate
              1. Applying Conditional Formats
          3. Using Live Data
            1. Importing Data and Content
              1. Smart Report
              2. Discover Lite
              3. Importing Existing Spreadsheets
            2. Blending Queries
        4. Creating Tabulate Visuals
          1. Drop Zones
          2. Formatting Panels
          3. Panel Layout
        5. Embedding in Present and Publish
        6. Managing Tabulations
          1. Saving Tabulations
          2. Printing and Exporting
          3. Mobile Access
  4. Viewer User
    1. Viewer Workflow Overview
    2. Viewer Home Page
      1. Viewer Home Menu
      2. Viewer System Info
      3. User Hub
    3. Content Management
      1. Content Types
      2. Content Manager
        1. Favorites
        2. Recents
        3. Content Explorer
        4. Most Used
        5. User Recommended
        6. Auto Recommended
        7. Content Search
      3. Schedules and Subscriptions
        1. Publications Board
        2. Alerts Board
        3. Subscriptions Board
        4. Workflow and Conversations Board
        5. Schedule Manager
          1. Alerts Manager
          2. Subscriptions Manager
    4. Interactive Content
      1. Data Discoveries
        1. Discovery Slicers
      2. Presentations
        1. Presentation Slicers
        2. Cross-Visual Interactions
        3. Panel Tools
      3. Viewer Interactions
        1. Conversations
        2. Alerts
        3. Analyze Further
          1. Members Search
    5. Manage Viewer Content
      1. Print and Export
      2. Subscribe to Content
        1. Link Back to Live Content
    6. Mobile and Tablet App
      1. Viewer Mobile Navigation
      2. Open Viewer Content
  5. Basic User
    1. Embed Experience
    2. Embed Hub
    3. Link Back to Live Content
    4. OData Link
  6. Mobile Client
    1. Mobile Phones
      1. Mobile Content Navigation
      2. Open Content
      3. Mobile Presentations
      4. Mobile Interactions
    2. Tablets
      1. App Menu
      2. Thumb Button and Context Menus
      3. Element Tree Navigation
      4. Accessing the Ribbons
      5. Accessing Submenus
      6. Quick Calculations
      7. Tablet Presentations
  7. Natural Language Interfaces
    1. Chatbot and Questions
      1. Access the Chatbot at Design Time
      2. Access the Chatbot at Runtime
      3. Chatbot Functions
        1. Speak to the Chatbot
      4. Writing Natural Language Queries
        1. NLQ: Asking a Basic Question
        2. NLQ: Advanced Intelligence
        3. NLQ: Visualizations
    2. Multiple LLM Engines
      1. Portable Language Model Guidance

Admin Help

  1. Admin Hub
    1. Diagnostic Dashboard
      1. Restarting Services
      2. Disabling Services
      3. In-Memory DB Status
    2. System Usage KPI
  2. Licensing
    1. License Change Wizard
    2. Deactivation of Pyramid
  3. Access
    1. Users
      1. Add Users
      2. Importing Users
      3. Domain Admin Rights
    2. Role Management
      1. Importing Roles
    3. Tenant Management
    4. Profiles
      1. Pro User Profile
      2. Analyst User Profile
      3. Viewer User Profile Settings
    5. User Defaults (Admin)
    6. Provisioning
  4. Security
    1. Authentication
      1. Multi-Factor Authentication
      2. Active Directory Setup
      3. Azure LDAPS Setup
      4. LDAP Setup
      5. SAML Authentication
        1. Azure SAML Setup
        2. ADFS SAML Setup
      6. OpenID Authentication
    2. Certificate Manager
      1. IMDB Encryption
    3. Server-Side Security
    4. Client Security
  5. Data
    1. Data Sources
      1. Data Source Setups
        1. Data Access with Windows Authentication
        2. Single Sign-on via OAuth
        3. Amazon OAuth Setup
        4. Box Setup
        5. Google OAuth Setup
        6. Microsoft Analysis Services Setup
        7. ODBC Setup
        8. Facebook Setup
        9. FTP Setup
        10. X (Twitter) Setup
        11. SAP BW Setup
        12. SAP HANA Setup
        13. SalesForce Setup
    2. Source Manager
      1. Data Source Servers (Admin)
      2. Database Management (Admin)
        1. Copy or Move a Data Model
      3. Data Model Management (Admin)
        1. Attribute Security
        2. Hierarchy Overlay
        3. Measure Security
        4. Measure Overlay
        5. Level Overlay
        6. Member Security
          1. Dynamic Member Security
          2. Security PQL Script Editor
    3. Pulse Nodes
    4. Kerberos Keytabs
    5. Custom Connectors
    6. Caching
    7. Query Limits
    8. Data Source Limits
    9. Global Settings
  6. Content
    1. Content Settings
    2. Migration Destinations
    3. Webhooks
    4. Custom Workflows
  7. Services
    1. General Settings
    2. Server Instances
      1. Service Memory Limits
    3. Run Time Services
    4. Task Services
    5. Solve Services
    6. Web Services
    7. File System
    8. Message Settings
  8. Schedules
    1. Task Manager
    2. Publication Schedules
    3. Alerts Schedules
    4. Subscriptions Schedules
    5. Models Schedules
    6. Auto Provisioning Jobs
    7. System Schedule
  9. Logs
    1. Entries
    2. Transaction Log
    3. Solve Logs
    4. System Log
    5. Deleted Items Log
    6. Log Settings
      1. Audit Trail Framework
  10. Mobile Devices
    1. Devices
    2. Mobile Devices Settings
  11. Design
    1. App Experience
    2. Themes
      1. Theme Editor
      2. Master Pages
    3. Custom Fonts
    4. Email Templates
      1. Add or Edit Email Template
    5. Hub Templates
      1. Build Hub Templates
      2. Hub Snippet Generator
  12. Geospatial
    1. Custom Maps
    2. Geospatial Settings
  13. AI and DSML
    1. AI Settings
    2. LLM Manager
    3. DSML Settings
    4. DSML Environments

Guides

  1. General Guides
    1. Pyramid Licensing
      1. Solve Access
    2. BI Office Content Conversion
    3. Generative AI Integration
    4. Dynamic Function Wizard
    5. Application Languages
    6. Version History
    7. Older Versions of Help
    8. Other Pyramid Help Resources
  2. Installation Guides
    1. Main Application
      1. System Requirements
      2. Quick Guide for Windows
      3. Quick Guide for Linux
      4. Upgrade Installations
      5. Unattended Installations
      6. Installation Steps
        1. Installation Rights
        2. Installation Directories
        3. Encryption and FIPS
          1. Encrypting Connections
        4. Server Deployment
          1. Adding and Removing Services
        5. Database Repository Installation
        6. Web Server Installation
          1. NGINX Web Server
          2. Create a Pyramid Website
        7. Initialization
        8. Post Installation Adjustments
        9. Offline Installation
          1. Offline Installation of R and Python
        10. Product Activation
          1. Trial Registrations
          2. New Deployment Activation
          3. Offline Registrations
          4. Changing Licensed Servers
      7. Repository Backups
        1. Recovery
    2. Kubernetes
      1. Recommendations for Kubernetes
      2. Kubernetes Initialization
        1. Kubernetes Unattended Initialization
      3. HELM Charts
        1. Unattended Kubernetes Configuration
        2. HELM Configuration
      4. Pyramid on AWS Kubernetes
      5. Pyramid on Azure Kubernetes
      6. Pyramid on GCP Kubernetes
      7. Kubernetes Configurator
    3. Pulse
      1. Pulse Installation Steps
    4. Cloud Server Quick Start
      1. Pyramid Analytics for AWS Marketplace
    5. Client Desktop
    6. System Maintenance Tools
    7. Uninstallation
  3. Configuration Guides
    1. Kerberos Delegation for Pyramid
    2. Amazon Load Balancer
  4. Deployment and Security Guides
    1. Scaling Pyramid
    2. Pyramid Usage
    3. User Deployment in Pyramid
    4. Application Security Overview
    5. Security Hardening Guide
    6. FIPS Compliance
    7. Mobile App Deployment
    8. Creating Accessible Content
  5. SAP Guides
    1. SAP SSO 'SNC' Setup Guide
    2. Support for SAP BW Features
    3. Troubleshooting Guide for SAP BW

Tech Reference

  1. Query & Function Overview
    1. PQL & MDX Language Reference
      1. MDX Language
        1. Semantic Library (MDX)
          1. Date-Time Functions
            1. ClosingPeriod
            2. LastPeriods
            3. MTD
            4. OpeningPeriod
            5. ParallelPeriod
            6. PeriodsToDate
            7. QTD
            8. WTD
            9. YTD
          2. Hierarchical Functions
            1. Ascendants
            2. Children
            3. Cousin
            4. Descendants
            5. Dimension
            6. Dimensions
            7. DrilldownLevel
            8. DrilldownLevelBottom
            9. DrilldownLevelTop
            10. DrilldownMember
            11. DrilldownMemberBottom
            12. DrilldownMemberTop
            13. DrillupLevel
            14. DrillupMember
            15. FirstChild
            16. FirstSibling
            17. Hierarchy
            18. LastChild
            19. LastSibling
            20. Level
            21. Levels
            22. Ordinal
            23. Parent
            24. RollupChildren
            25. Root
            26. Siblings
          3. KPI Functions
            1. KPICurrentTimeMember
            2. KPIGoal
            3. KPIStatus
            4. KPITrend
            5. KPIValue
            6. KPIWeight
          4. List Functions
            1. AddCalculatedMembers
            2. AllMembers
            3. Ancestors
            4. Axis
            5. BottomCount
            6. BottomPercent
            7. BottomSum
            8. Crossjoin
            9. Distinct
            10. Except
            11. Exists
            12. Extract
            13. Filter
            14. Generate
            15. Head
            16. Hierarchize
            17. Intersect
            18. Leaves
            19. MeasureGroupMeasures
            20. Members
            21. NameToSet
            22. NonEmpty
            23. NonEmptyCrossjoin
            24. Order
            25. StripCalculatedMembers
            26. Subset
            27. Tail
            28. ToggleDrillState
            29. TopCount
            30. TopPercent
            31. TopSum
            32. Union
            33. Unorder
          5. Logical Functions
            1. Error
            2. IIf
            3. IsAncestor
            4. IsEmpty
            5. IsGeneration
            6. IsLeaf
            7. IsSibling
          6. Member Functions
            1. Ancestor
            2. Current
            3. CurrentMember
            4. DataMember
            5. DefaultMember
            6. Item
            7. Lag
            8. Lead
            9. LinkMember
            10. NextMember
            11. PrevMember
            12. UnknownMember
          7. Other Functions
            1. CalculationCurrentPass
            2. CalculationPassValue
            3. CoalesceEmpty
            4. CurrentOrdinal
            5. LookupCube
            6. Properties
            7. SetToArray
            8. UserName
            9. ValidMeasure
            10. Value
          8. Statistical Functions
            1. Aggregate
            2. Avg
            3. Correlation
            4. Count
            5. Covariance
            6. CovarianceN
            7. DistinctCount
            8. LinRegIntercept
            9. LinRegPoint
            10. LinRegR2
            11. LinRegSlope
            12. LinRegVariance
            13. Max
            14. Median
            15. Min
            16. Predict
            17. Rank
            18. Stdev
            19. StdevP
            20. Sum
            21. Variance
            22. VarianceP
            23. VisualTotals
          9. String Functions
            1. MemberToStr
            2. Name
            3. SetToStr
            4. StrToMember
            5. StrToSet
            6. StrToTuple
            7. StrToValue
            8. TupleToStr
            9. UniqueName
        2. VBA Library (MDX)
          1. Conversion Functions
            1. CBool
            2. CByte
            3. CCur
            4. CDate
            5. CDbl
            6. CDec
            7. CInt
            8. CLng
            9. CSng
            10. CStr
            11. CVar
            12. TypeName
          2. Date-Time Functions
            1. Date
            2. DateAdd
            3. DateDiff
            4. DatePart
            5. DateSerial
            6. DateValue
            7. Day
            8. Hour
            9. Minute
            10. Month
            11. Now
            12. Second
            13. Timer
            14. TimeSerial
            15. TimeValue
            16. Weekday
            17. Year
          3. Financial Functions
            1. DDB
            2. FV
            3. IPmt
            4. IRR
            5. MIRR
            6. NPer
            7. NPV
            8. Pmt
            9. PPmt
            10. PV
            11. Rate
            12. SLN
            13. SYD
          4. Logical Functions
            1. Choose
            2. Iif
            3. IsArray
            4. IsDate
            5. IsEmpty
            6. IsError
            7. IsMissing
            8. IsNull
            9. IsNumeric
            10. Switch
          5. Math Functions
            1. Abs
            2. Atn
            3. Cos
            4. Exp
            5. Fix
            6. Int
            7. Log
            8. QBColor
            9. RGB
            10. Rnd
            11. Round
            12. Sgn
            13. Sin
            14. Sqr
            15. Tan
          6. String Functions
            1. Asc
            2. Chr
            3. Format
            4. Hex
            5. InStr
            6. LCase
            7. Left
            8. Len
            9. LTrim
            10. Mid
            11. Oct
            12. Partition
            13. Right
            14. RTrim
            15. Space
            16. Str
            17. StrComp
            18. StrConv
            19. String
            20. Trim
            21. UCase
            22. Val
        3. Spreadsheet Library (PQL)
          1. Pyramid Functions
            1. DATA
            2. MEMBER
            3. PARAMETER
            4. SLICER
            5. SLICERCAPTION
          2. Database Functions
            1. DAVERAGE
            2. DCOUNT
            3. DCOUNTA
            4. DGET
            5. DMAX
            6. DMIN
            7. DPRODUCT
            8. DSTDEV
            9. DSTDEVP
            10. DSUM
            11. DVAR
            12. DVARP
          3. Date & Time Functions
            1. DATE
            2. DATEDIF
            3. DATEVALUE
            4. DAY
            5. DAYS
            6. DAYS360
            7. EDATE
            8. EOMONTH
            9. HOUR
            10. ISOWEEKNUM
            11. MINUTE
            12. MONTH
            13. NETWORKDAYS
            14. NETWORKDAYS.INTL
            15. NOW
            16. SECOND
            17. TIME
            18. TIMEVALUE
            19. TODAY
            20. WEEKDAY
            21. WEEKNUM
            22. WORKDAY
            23. WORKDAY.INTL
            24. YEAR
            25. YEARFRAC
          4. Engineering Functions
            1. BESSELI
            2. BESSELJ
            3. BESSELK
            4. BESSELY
            5. BIN2DEC
            6. BIN2HEX
            7. BIN2OCT
            8. BITAND
            9. BITLSHIFT
            10. BITOR
            11. BITRSHIFT
            12. BITXOR
            13. COMPLEX
            14. CONVERT
            15. DEC2BIN
            16. DEC2HEX
            17. DEC2OCT
            18. DELTA
            19. ERF
            20. ERF.PRECISE
            21. ERFC
            22. ERFC.PRECISE
            23. GESTEP
            24. HEX2BIN
            25. HEX2DEC
            26. HEX2OCT
            27. IMABS
            28. IMAGINARY
            29. IMARGUMENT
            30. IMCONJUGATE
            31. IMCOS
            32. IMCOSH
            33. IMCOT
            34. IMCSC
            35. IMCSCH
            36. IMDIV
            37. IMEXP
            38. IMLN
            39. IMLOG10
            40. IMLOG2
            41. IMPOWER
            42. IMPRODUCT
            43. IMREAL
            44. IMSEC
            45. IMSECH
            46. IMSIN
            47. IMSINH
            48. IMSQRT
            49. IMSUB
            50. IMSUM
            51. IMTAN
            52. OCT2BIN
            53. OCT2DEC
            54. OCT2HEX
          5. Financial Functions
            1. ACCRINT
            2. ACCRINTM
            3. AMORDEGRC
            4. AMORLINC
            5. COUPDAYBS
            6. COUPDAYS
            7. COUPDAYSNC
            8. COUPNCD
            9. COUPNUM
            10. COUPPCD
            11. CUMIPMT
            12. CUMPRINC
            13. DB
            14. DDB
            15. DISC
            16. DOLLARDE
            17. DOLLARFR
            18. DURATION
            19. EFFECT
            20. FV
            21. FVSCHEDULE
            22. INTRATE
            23. IPMT
            24. IRR
            25. ISPMT
            26. MDURATION
            27. MIRR
            28. NOMINAL
            29. NPER
            30. NPV
            31. ODDFPRICE
            32. ODDFYIELD
            33. ODDLPRICE
            34. ODDLYIELD
            35. EURO
            36. EUROCONVERT
            37. PDURATION
            38. PMT
            39. PPMT
            40. PRICE
            41. PRICEDISC
            42. PRICEMAT
            43. PV
            44. RATE
            45. RECEIVED
            46. RRI
            47. SLN
            48. SYD
            49. TBILLEQ
            50. TBILLPRICE
            51. TBILLYIELD
            52. VDB
            53. XIRR
            54. XNPV
            55. YIELD
            56. YIELDDISC
            57. YIELDMAT
          6. Information Functions
            1. ERROR.TYPE
            2. ISBLANK
            3. ISERR
            4. ISERROR
            5. ISEVEN
            6. ISFORMULA
            7. ISLOGICAL
            8. ISNA
            9. ISNONTEXT
            10. ISNUMBER
            11. ISODD
            12. ISOMITTED
            13. ISREF
            14. ISTEXT
            15. N
            16. NA
            17. SHEET
            18. SHEETS
            19. TYPE
          7. Logical Functions
            1. AND
            2. BYCOL
            3. BYROW
            4. IF
            5. IFERROR
            6. IFNA
            7. IFS
            8. LAMBDA
            9. LET
            10. MAKEARRAY
            11. MAP
            12. NOT
            13. OR
            14. REDUCE
            15. SCAN
            16. SWITCH
            17. XOR
          8. Lookup Functions
            1. ADDRESS
            2. AREAS
            3. CHOOSE
            4. CHOOSECOLS
            5. CHOOSEROWS
            6. COLUMN
            7. COLUMNS
            8. DROP
            9. EXPEND
            10. FILTER
            11. FORMULATEXT
            12. HLOOKUP
            13. HSTACK
            14. HYPERLINK
            15. INDEX
            16. INDIRECT
            17. LOOKUP
            18. MATCH
            19. OFFSET
            20. ROW
            21. ROWS
            22. SORT
            23. SORTBY
            24. TOCOL
            25. TOROW
            26. TRANSPOSE
            27. UNIQUE
            28. VLOOKUP
            29. VSTACK
            30. WRAPCOLS
            31. WRAPROWS
            32. XLOOKUP
            33. XMATCH
          9. Math & Trig Functions
            1. ABS
            2. ACOS
            3. ACOSH
            4. ACOT
            5. ACOTH
            6. AGGREGATE
            7. ARABIC
            8. ASIN
            9. ASINH
            10. ATAN
            11. ATAN2
            12. ATANH
            13. BASE
            14. CEILING
            15. CEILING.MATH
            16. CEILING.PRECISE
            17. COMBIN
            18. COMBINA
            19. COS
            20. COSH
            21. COT
            22. COTH
            23. CSC
            24. CSCH
            25. DECIMAL
            26. DEGREES
            27. EVEN
            28. EXP
            29. FACT
            30. FACTDOUBLE
            31. FLOOR.MATH
            32. FLOOR.PRECISE
            33. GCD
            34. INT
            35. ISO.CEILING
            36. LCM
            37. LN
            38. LOG
            39. LOG10
            40. MDETERM
            41. MINVERSE
            42. MMULT
            43. MOD
            44. MROUND
            45. MULTINOMIAL
            46. ODD
            47. PI
            48. POWER
            49. PRODUCT
            50. QUOTIENT
            51. RADIANS
            52. RAND
            53. RANDARRAY
            54. RANDBETWEEN
            55. ROMAN
            56. ROUND
            57. ROUNDDOWN
            58. ROUNDUP
            59. SEC
            60. SECH
            61. SEQUENCE
            62. SERIESSUM
            63. SIGN
            64. SIN
            65. SINH
            66. SQRT
            67. SQRTPI
            68. SUBTOTAL
            69. SUM
            70. SUMIF
            71. SUMIFS
            72. SUMPRODUCT
            73. SUMSQ
            74. SUMX2MY2
            75. SUMX2PY2
            76. SUMXMY2
            77. TAN
            78. TANH
            79. TRUNC
          10. Statistical Functions
            1. AVEDEV
            2. AVERAGE
            3. AVERAGEA
            4. AVERAGEIF
            5. AVERAGEIFS
            6. BETA.DIST
            7. BETA.INV
            8. BINOM.DIST
            9. BINOM.DIST.RANGE
            10. BINOM.INV
            11. CHISQ.DIST
            12. CHISQ.DIST.RT
            13. CHISQ.INV
            14. CHISQ.INV.RT
            15. CHISQ.TEST
            16. CONFIDENCE.NORM
            17. CONFIDENCE.T
            18. CORREL
            19. COUNT
            20. COUNTA
            21. COUNTBLANK
            22. COUNTIF
            23. COUNTIFS
            24. COVARIANCE.P
            25. COVARIANCE.S
            26. DEVSQ
            27. EXPON.DIST
            28. F.DIST
            29. F.DIST.RT
            30. F.INV
            31. F.INV.RT
            32. F.TEST
            33. FINV
            34. FISHER
            35. FISHERINV
            36. FORECAST
            37. FREQUENCY
            38. GAMMA
            39. GAMMA.DIST
            40. GAMMA.INV
            41. GAMMALN
            42. GAMMALN.PRECISE
            43. GAUSS
            44. GEOMEAN
            45. GROWTH
            46. HARMEAN
            47. HYPGEOM.DIST
            48. INTERCEPT
            49. KURT
            50. LARGE
            51. LINEST
            52. LOGEST
            53. LOGNORM.DIST
            54. LOGNORM.INV
            55. MAX
            56. MAXA
            57. MAXIFS
            58. MEDIAN
            59. MIN
            60. MINA
            61. MINIFS
            62. MODE.MULT
            63. MODE.SNGL
            64. NEGBINOM.DIST
            65. NORM.DIST
            66. NORM.INV
            67. NORM.S.DIST
            68. NORM.S.INV
            69. PEARSON
            70. PERCENTILE.EXC
            71. PERCENTILE.INC
            72. PERCENTRANK.EXC
            73. PERCENTRANK.INC
            74. PERMUT
            75. PERMUTATIONA
            76. PHI
            77. POISSON.DIST
            78. PROB
            79. QUARTILE.EXC
            80. QUARTILE.INC
            81. RANK.AVG
            82. RANK.EQ
            83. RSQ
            84. SKEW
            85. SKEW.P
            86. SLOPE
            87. SMALL
            88. STANDARDIZE
            89. STDEV.P
            90. STDEV.S
            91. STDEVA
            92. STDEVPA
            93. STEYX
            94. T.DIST
            95. T.DIST.2T
            96. T.DIST.RT
            97. T.INV
            98. T.INV.2T
            99. T.TEST
            100. TREND
            101. TRIMMEAN
            102. VAR.P
            103. VAR.S
            104. VARA
            105. VARPA
            106. WEIBULL.DIST
            107. Z.TEST
          11. Text Functions
            1. ASC
            2. BAHTTEXT
            3. CHAR
            4. CLEAN
            5. CODE
            6. CONCAT
            7. CONCATENATE
            8. DBCS
            9. DOLLAR
            10. EXACT
            11. FIND
            12. FIXED
            13. LEFT
            14. LEN
            15. LOWER
            16. MID
            17. OBJECT
            18. PROPER
            19. REPLACE
            20. REPT
            21. RIGHT
            22. SEARCH
            23. SEARCHB
            24. SUBSTITUTE
            25. T
            26. TEXT
            27. TEXTAFTER
            28. TEXTBEFORE
            29. TEXTJOIN
            30. TEXTSPLIT
            31. TRIM
            32. UNICHAR
            33. UNICODE
            34. UPPER
            35. VALUE
          12. Web Functions
            1. ENCODEURL
            2. FILTERJSON
            3. WEBSERVICE
          13. Compatibility Functions
            1. BETADIST
            2. BETAINV
            3. BINOMDIST
            4. CHIDIST
            5. CHIINV
            6. CHITEST
            7. CONFIDENCE
            8. COVAR
            9. CRITBINOM
            10. EXPONDIST
            11. FDIST
            12. FLOOR
            13. FTEST
            14. GAMMADIST
            15. GAMMAINV
            16. HYPGEOMDIST
            17. LOGINV
            18. LOGNORMDIST
            19. MODE
            20. NEGBINOMDIST
            21. NORMDIST
            22. NORMINV
            23. NORMSDIST
            24. NORMSINV
            25. PERCENTILE
            26. PERCENTRANK
            27. POISSON
            28. QUARTILE
            29. RANK
            30. STDEV
            31. STDEVP
            32. TDIST
            33. TINV
            34. TTEST
            35. VAR
            36. VARP
            37. WEIBULL
            38. ZTEST
    2. PQL Language
      1. Action Library (PQL)
        1. Cross-Model Functions
          1. DimensionCaption
          2. DimensionUniqueName
          3. HierarchyCaption
          4. HierarchyUniqueName
          5. MemberCaption
          6. MemberKey
          7. MemberUniqueName
          8. SourceMember
          9. TargetMember
        2. Jump Functions
          1. Captions
          2. CellValue
          3. ItemExists
          4. UniqueNames
      2. Common Library (PQL)
        1. Date-Time Functions
          1. AddDays
          2. AddHours
          3. AddMinutes
          4. AddMonths
          5. AddQuarters
          6. AddWeeks
          7. AddYears
          8. CreateDate
          9. Date
          10. DateDiff
          11. DateFormat
          12. DateTime
          13. DateToTimeStamp
          14. DayNumber
          15. Hour
          16. Minute
          17. Month
          18. MonthNumber
          19. Quarter
          20. QuarterNumber
          21. Second
          22. StringToDate
          23. StringtoDateTime
          24. TimeStampToDate
          25. Week
          26. WeekNumber
          27. Year
        2. Formats Functions
          1. AutoFormat
          2. CurrencyDollars0
          3. CurrencyDollars2
          4. CurrencyEuros0
          5. CurrencyEuros2
          6. CurrencyPounds0
          7. CurrencyPounds2
          8. CurrencyRands0
          9. CurrencyRands2
          10. CurrencyShekels0
          11. CurrencyShekels2
          12. CurrencySwissFrancs0
          13. CurrencySwissFrancs2
          14. DateAmerican
          15. DateTimeAmerican
          16. DateTimeUniversal
          17. DateTimeWestern
          18. DateUniversal
          19. DateWestern
          20. Number0
          21. Number1
          22. Number2
          23. NumberBillions
          24. NumberMillions
          25. NumberThousands
          26. Percent0
          27. Percent1
          28. Percent2
        3. Geo Functions
          1. GeoDistance
        4. Identity Functions
          1. ApplicationCulture
          2. UserAdAccount
          3. UserAdDomain
          4. UserCustomData
          5. UserEmail
          6. UserFirstName
          7. UserLastName
          8. UserName
          9. UserPrincipalName
          10. UserPrincipalNameAlt
          11. UserProxyAccount
          12. UserProxyAccount2
          13. UserRoles
          14. UserRolesSet
          15. UserTenant
        5. Logical Functions
          1. Case
          2. Equals
          3. If
          4. IfNull
          5. IsNAN
          6. Loop
          7. LoopVector
          8. NotEquals
          9. Switch
        6. Math Functions
          1. Absolute
          2. ArcCos
          3. ArcSin
          4. ArcTan
          5. Ceiling
          6. Coalesce
          7. ConvertToNumber
          8. Cos
          9. Ctan
          10. Divide
          11. E
          12. Exponent
          13. Floor
          14. Ln
          15. Log
          16. Log10
          17. Log2
          18. Multiply
          19. PI
          20. Power
          21. Random
          22. RandomDouble
          23. RemoveBlanks
          24. RGB
          25. Round
          26. Sin
          27. Tan
          28. ToDegrees
          29. ToRadians
        7. Statistical Functions
          1. Average
          2. Correlation
          3. Covariance
          4. DataSet
          5. IndexOfMax
          6. IndexOfMin
          7. Maximum
          8. Median
          9. Minimum
          10. PercentileRank
          11. Rank
          12. StandardDeviation
          13. Sum
        8. String Functions
          1. Contains
          2. EndsWith
          3. FindByPattern
          4. Format
          5. HasItem
          6. IndexOf
          7. Left
          8. Length
          9. LLM
          10. Replace
          11. Right
          12. StartsWith
          13. StringJoin
          14. SubString
          15. ToLower
          16. ToProper
          17. ToString
          18. ToUpper
          19. Trim
          20. TrimLeft
          21. TrimRight
          22. UrlDecode
          23. UrlEncode
      3. Dynamic Library (PQL)
        1. Column Functions
          1. DataSetColumn
          2. DataSetColumnRange
          3. FindColumnNumber
          4. LastColumn
          5. LookupMaxColumn
          6. LookupMinColumn
          7. NumberOfColumns
          8. TotalColumn
        2. Grid Functions
          1. CountAvg
          2. CountPercentile
          3. Data
          4. Forecast
          5. ForecastPercent
          6. ForecastValue
          7. FormattedData
          8. GridCountAvg
          9. GridCountPercentile
          10. IsCellEmpty
          11. IsCellValid
          12. IsEmptyQuery
          13. IsQueryValid
          14. Label
          15. LinearTrendSlopeValue
          16. MaxGrid
          17. MinGrid
          18. NumberOfCells
          19. Outlier
          20. TotalGrid
        3. Markup Functions
          1. Bold
          2. Bullet
          3. FontFormat
          4. HyperLink
          5. Image
          6. Italics
          7. LineBreak
          8. OrderedList
          9. Underline
          10. UnorderedList
        4. Row Functions
          1. DataSetRow
          2. DataSetRowRange
          3. FindRowNumber
          4. LastRow
          5. LookupMaxRow
          6. LookupMinRow
          7. NumberOfRows
          8. TotalRow
        5. Smart Functions
          1. SmartInsights
          2. SmartInsightsCategorical
      4. Granular Library (PQL)
        1. Date-Time Functions
          1. AddDays
          2. AddHours
          3. AddMinutes
          4. AddMonths
          5. AddQuarters
          6. AddWeeks
          7. AddYears
          8. Age
          9. Date
          10. DateDiff
          11. DateFormat
          12. DayNumber
          13. Hour
          14. Minute
          15. Month
          16. MonthName
          17. MonthNumber
          18. Now
          19. Quarter
          20. QuarterNumber
          21. Second
          22. Today
          23. Week
          24. WeekNumber
          25. Year
        2. Identity Functions
          1. UserAdAccount
          2. UserAdDomain
          3. UserCustomData
          4. UserEmail
          5. UserFirstName
          6. UserLastName
          7. UserName
          8. UserPrincipalName
          9. UserPrincipalNameAlt
          10. UserProxyAccount
          11. UserProxyAccount2
          12. UserRoles
          13. UserTenant
        3. Logical Functions
          1. Case
          2. If
          3. IsNull
          4. Not
          5. NullIfEqual
          6. Switch
        4. Math Functions
          1. Abs
          2. ArcCos
          3. ArcSin
          4. ArcTan
          5. Bin
          6. Ceiling
          7. Coalesce
          8. Cos
          9. Ctan
          10. E
          11. Exp
          12. Floor
          13. Log
          14. Log10
          15. Mod
          16. PI
          17. Power
          18. Random
          19. Round
          20. Sin
          21. Sqrt
          22. Tan
          23. ToDecimal
          24. ToDegrees
          25. ToInteger
          26. ToRadians
        5. String Functions
          1. Concat
          2. Contains
          3. EndsWith
          4. IndexOf
          5. Left
          6. Length
          7. Replace
          8. Right
          9. StartsWith
          10. SubString
          11. ToLower
          12. ToString
          13. ToUpper
          14. WordCount
      5. Semantic Library (PQL)
        1. Aggregate Functions
          1. Average
          2. Count
          3. CumulativeTimeSum
          4. DistinctCount
          5. FirstChild
          6. FirstQuartile
          7. LastChild
          8. Maximum
          9. Median
          10. Minimum
          11. Sum
          12. Text
          13. ThirdQuartile
        2. Date-Time Functions
          1. AddDays
          2. AddMonths
          3. AddQuarters
          4. AddWeeks
          5. AddYears
          6. ClosingPeriod
          7. CreateDate
          8. CurrentPeriod
          9. FullMonth
          10. FullQuarter
          11. FullWeek
          12. Fullyear
          13. MTD
          14. OpeningPeriod
          15. ParallelPeriod
          16. ParallelPeriods
          17. QTD
          18. WTD
          19. YTD
        3. Hierarchical Functions
          1. AllDescendants
          2. Ancestor
          3. Ascendants
          4. Children
          5. Cousin
          6. Descendants
          7. FirstChild
          8. FirstSibling
          9. GrandParent
          10. IsAncestor
          11. IsLeaf
          12. IsSibling
          13. LastChild
          14. LastSibling
          15. LeafDescendants
          16. Level
          17. Levels
          18. Ordinal
          19. Parent
          20. Siblings
        4. List Functions
          1. AllMembers
          2. BottomCount
          3. BottomPercent
          4. BottomSum
          5. Except
          6. Filter
          7. Head
          8. Intersect
          9. Leaves
          10. NonEmpty
          11. Not
          12. Order
          13. Range
          14. Subset
          15. Tail
          16. TopCount
          17. TopPercent
          18. TopSum
          19. Union
        5. Logical Functions
          1. HasChildren
          2. HasDataPoint
          3. HasDataPoints
          4. If
          5. ListContainsAll
          6. ListContainsAny
          7. Switch
        6. Member Functions
          1. ClosingElement
          2. CurrentMember
          3. DefaultMember
          4. FirstElement
          5. GetElement
          6. Lag
          7. LastElement
          8. Lead
          9. NextMember
          10. Offset
          11. OpeningElement
          12. PrevMember
        7. Statistical Functions
          1. Aggregate
          2. Average
          3. Correlation
          4. Count
          5. Covariance
          6. CovarianceP
          7. ExpRegA
          8. ExpRegB
          9. ExpRegPoint
          10. ExpRegR2
          11. LinRegIntercept
          12. LinRegPoint
          13. LinRegR2
          14. LinRegSlope
          15. LogRegA
          16. LogRegB
          17. LogRegPoint
          18. LogRegR2
          19. Maximum
          20. Median
          21. Minimum
          22. Multiply
          23. Percentile
          24. PowerRegA
          25. PowerRegB
          26. PowerRegPoint
          27. PowerRegR2
          28. Rank
          29. Stdev
          30. StdevP
          31. Sum
          32. Variance
          33. VarianceP
        8. String Functions
          1. Caption
          2. Contains
          3. EndsWith
          4. Equals
          5. ModelCulture
          6. StartsWith
          7. StrToDate
          8. StrToMember
          9. StrToSet
          10. UniqueName
      6. Spreadsheet Library (PQL)
        1. Pyramid Functions
          1. DATA
          2. MEMBER
          3. PARAMETER
          4. SLICER
          5. SLICERCAPTION
        2. Database Functions
          1. DAVERAGE
          2. DCOUNT
          3. DCOUNTA
          4. DGET
          5. DMAX
          6. DMIN
          7. DPRODUCT
          8. DSTDEV
          9. DSTDEVP
          10. DSUM
          11. DVAR
          12. DVARP
        3. Date & Time Functions
          1. DATE
          2. DATEDIF
          3. DATEVALUE
          4. DAY
          5. DAYS
          6. DAYS360
          7. EDATE
          8. EOMONTH
          9. HOUR
          10. ISOWEEKNUM
          11. MINUTE
          12. MONTH
          13. NETWORKDAYS
          14. NETWORKDAYS.INTL
          15. NOW
          16. SECOND
          17. TIME
          18. TIMEVALUE
          19. TODAY
          20. WEEKDAY
          21. WEEKNUM
          22. WORKDAY
          23. WORKDAY.INTL
          24. YEAR
          25. YEARFRAC
        4. Engineering Functions
          1. BESSELI
          2. BESSELJ
          3. BESSELK
          4. BESSELY
          5. BIN2DEC
          6. BIN2HEX
          7. BIN2OCT
          8. BITAND
          9. BITLSHIFT
          10. BITOR
          11. BITRSHIFT
          12. BITXOR
          13. COMPLEX
          14. CONVERT
          15. DEC2BIN
          16. DEC2HEX
          17. DEC2OCT
          18. DELTA
          19. ERF
          20. ERF.PRECISE
          21. ERFC
          22. ERFC.PRECISE
          23. GESTEP
          24. HEX2BIN
          25. HEX2DEC
          26. HEX2OCT
          27. IMABS
          28. IMAGINARY
          29. IMARGUMENT
          30. IMCONJUGATE
          31. IMCOS
          32. IMCOSH
          33. IMCOT
          34. IMCSC
          35. IMCSCH
          36. IMDIV
          37. IMEXP
          38. IMLN
          39. IMLOG10
          40. IMLOG2
          41. IMPOWER
          42. IMPRODUCT
          43. IMREAL
          44. IMSEC
          45. IMSECH
          46. IMSIN
          47. IMSINH
          48. IMSQRT
          49. IMSUB
          50. IMSUM
          51. IMTAN
          52. OCT2BIN
          53. OCT2DEC
          54. OCT2HEX
        5. Financial Functions
          1. ACCRINT
          2. ACCRINTM
          3. AMORDEGRC
          4. AMORLINC
          5. COUPDAYBS
          6. COUPDAYS
          7. COUPDAYSNC
          8. COUPNCD
          9. COUPNUM
          10. COUPPCD
          11. CUMIPMT
          12. CUMPRINC
          13. DB
          14. DDB
          15. DISC
          16. DOLLARDE
          17. DOLLARFR
          18. DURATION
          19. EFFECT
          20. FV
          21. FVSCHEDULE
          22. INTRATE
          23. IPMT
          24. IRR
          25. ISPMT
          26. MDURATION
          27. MIRR
          28. NOMINAL
          29. NPER
          30. NPV
          31. ODDFPRICE
          32. ODDFYIELD
          33. ODDLPRICE
          34. ODDLYIELD
          35. EURO
          36. EUROCONVERT
          37. PDURATION
          38. PMT
          39. PPMT
          40. PRICE
          41. PRICEDISC
          42. PRICEMAT
          43. PV
          44. RATE
          45. RECEIVED
          46. RRI
          47. SLN
          48. SYD
          49. TBILLEQ
          50. TBILLPRICE
          51. TBILLYIELD
          52. VDB
          53. XIRR
          54. XNPV
          55. YIELD
          56. YIELDDISC
          57. YIELDMAT
        6. Information Functions
          1. ERROR.TYPE
          2. ISBLANK
          3. ISERR
          4. ISERROR
          5. ISEVEN
          6. ISFORMULA
          7. ISLOGICAL
          8. ISNA
          9. ISNONTEXT
          10. ISNUMBER
          11. ISODD
          12. ISOMITTED
          13. ISREF
          14. ISTEXT
          15. N
          16. NA
          17. SHEET
          18. SHEETS
          19. TYPE
        7. Logical Functions
          1. AND
          2. BYCOL
          3. BYROW
          4. IF
          5. IFERROR
          6. IFNA
          7. IFS
          8. LAMBDA
          9. LET
          10. MAKEARRAY
          11. MAP
          12. NOT
          13. OR
          14. REDUCE
          15. SCAN
          16. SWITCH
          17. XOR
        8. Lookup Functions
          1. ADDRESS
          2. AREAS
          3. CHOOSE
          4. CHOOSECOLS
          5. CHOOSEROWS
          6. COLUMN
          7. COLUMNS
          8. DROP
          9. EXPEND
          10. FILTER
          11. FORMULATEXT
          12. HLOOKUP
          13. HSTACK
          14. HYPERLINK
          15. INDEX
          16. INDIRECT
          17. LOOKUP
          18. MATCH
          19. OFFSET
          20. ROW
          21. ROWS
          22. SORT
          23. SORTBY
          24. TOCOL
          25. TOROW
          26. TRANSPOSE
          27. UNIQUE
          28. VLOOKUP
          29. VSTACK
          30. WRAPCOLS
          31. WRAPROWS
          32. XLOOKUP
          33. XMATCH
        9. Math & Trig Functions
          1. ABS
          2. ACOS
          3. ACOSH
          4. ACOT
          5. ACOTH
          6. AGGREGATE
          7. ARABIC
          8. ASIN
          9. ASINH
          10. ATAN
          11. ATAN2
          12. ATANH
          13. BASE
          14. CEILING
          15. CEILING.MATH
          16. CEILING.PRECISE
          17. COMBIN
          18. COMBINA
          19. COS
          20. COSH
          21. COT
          22. COTH
          23. CSC
          24. CSCH
          25. DECIMAL
          26. DEGREES
          27. EVEN
          28. EXP
          29. FACT
          30. FACTDOUBLE
          31. FLOOR.MATH
          32. FLOOR.PRECISE
          33. GCD
          34. INT
          35. ISO.CEILING
          36. LCM
          37. LN
          38. LOG
          39. LOG10
          40. MDETERM
          41. MINVERSE
          42. MMULT
          43. MOD
          44. MROUND
          45. MULTINOMIAL
          46. ODD
          47. PI
          48. POWER
          49. PRODUCT
          50. QUOTIENT
          51. RADIANS
          52. RAND
          53. RANDARRAY
          54. RANDBETWEEN
          55. ROMAN
          56. ROUND
          57. ROUNDDOWN
          58. ROUNDUP
          59. SEC
          60. SECH
          61. SEQUENCE
          62. SERIESSUM
          63. SIGN
          64. SIN
          65. SINH
          66. SQRT
          67. SQRTPI
          68. SUBTOTAL
          69. SUM
          70. SUMIF
          71. SUMIFS
          72. SUMPRODUCT
          73. SUMSQ
          74. SUMX2MY2
          75. SUMX2PY2
          76. SUMXMY2
          77. TAN
          78. TANH
          79. TRUNC
        10. Statistical Functions
          1. AVEDEV
          2. AVERAGE
          3. AVERAGEA
          4. AVERAGEIF
          5. AVERAGEIFS
          6. BETA.DIST
          7. BETA.INV
          8. BINOM.DIST
          9. BINOM.DIST.RANGE
          10. BINOM.INV
          11. CHISQ.DIST
          12. CHISQ.DIST.RT
          13. CHISQ.INV
          14. CHISQ.INV.RT
          15. CHISQ.TEST
          16. CONFIDENCE.NORM
          17. CONFIDENCE.T
          18. CORREL
          19. COUNT
          20. COUNTA
          21. COUNTBLANK
          22. COUNTIF
          23. COUNTIFS
          24. COVARIANCE.P
          25. COVARIANCE.S
          26. DEVSQ
          27. EXPON.DIST
          28. F.DIST
          29. F.DIST.RT
          30. F.INV
          31. F.INV.RT
          32. F.TEST
          33. FINV
          34. FISHER
          35. FISHERINV
          36. FORECAST
          37. FREQUENCY
          38. GAMMA
          39. GAMMA.DIST
          40. GAMMA.INV
          41. GAMMALN
          42. GAMMALN.PRECISE
          43. GAUSS
          44. GEOMEAN
          45. GROWTH
          46. HARMEAN
          47. HYPGEOM.DIST
          48. INTERCEPT
          49. KURT
          50. LARGE
          51. LINEST
          52. LOGEST
          53. LOGNORM.DIST
          54. LOGNORM.INV
          55. MAX
          56. MAXA
          57. MAXIFS
          58. MEDIAN
          59. MIN
          60. MINA
          61. MINIFS
          62. MODE.MULT
          63. MODE.SNGL
          64. NEGBINOM.DIST
          65. NORM.DIST
          66. NORM.INV
          67. NORM.S.DIST
          68. NORM.S.INV
          69. PEARSON
          70. PERCENTILE.EXC
          71. PERCENTILE.INC
          72. PERCENTRANK.EXC
          73. PERCENTRANK.INC
          74. PERMUT
          75. PERMUTATIONA
          76. PHI
          77. POISSON.DIST
          78. PROB
          79. QUARTILE.EXC
          80. QUARTILE.INC
          81. RANK.AVG
          82. RANK.EQ
          83. RSQ
          84. SKEW
          85. SKEW.P
          86. SLOPE
          87. SMALL
          88. STANDARDIZE
          89. STDEV.P
          90. STDEV.S
          91. STDEVA
          92. STDEVPA
          93. STEYX
          94. T.DIST
          95. T.DIST.2T
          96. T.DIST.RT
          97. T.INV
          98. T.INV.2T
          99. T.TEST
          100. TREND
          101. TRIMMEAN
          102. VAR.P
          103. VAR.S
          104. VARA
          105. VARPA
          106. WEIBULL.DIST
          107. Z.TEST
        11. Text Functions
          1. ASC
          2. BAHTTEXT
          3. CHAR
          4. CLEAN
          5. CODE
          6. CONCAT
          7. CONCATENATE
          8. DBCS
          9. DOLLAR
          10. EXACT
          11. FIND
          12. FIXED
          13. LEFT
          14. LEN
          15. LOWER
          16. MID
          17. OBJECT
          18. PROPER
          19. REPLACE
          20. REPT
          21. RIGHT
          22. SEARCH
          23. SEARCHB
          24. SUBSTITUTE
          25. T
          26. TEXT
          27. TEXTAFTER
          28. TEXTBEFORE
          29. TEXTJOIN
          30. TEXTSPLIT
          31. TRIM
          32. UNICHAR
          33. UNICODE
          34. UPPER
          35. VALUE
        12. Web Functions
          1. ENCODEURL
          2. FILTERJSON
          3. WEBSERVICE
        13. Compatibility Functions
          1. BETADIST
          2. BETAINV
          3. BINOMDIST
          4. CHIDIST
          5. CHIINV
          6. CHITEST
          7. CONFIDENCE
          8. COVAR
          9. CRITBINOM
          10. EXPONDIST
          11. FDIST
          12. FLOOR
          13. FTEST
          14. GAMMADIST
          15. GAMMAINV
          16. HYPGEOMDIST
          17. LOGINV
          18. LOGNORMDIST
          19. MODE
          20. NEGBINOMDIST
          21. NORMDIST
          22. NORMINV
          23. NORMSDIST
          24. NORMSINV
          25. PERCENTILE
          26. PERCENTRANK
          27. POISSON
          28. QUARTILE
          29. RANK
          30. STDEV
          31. STDEVP
          32. TDIST
          33. TINV
          34. TTEST
          35. VAR
          36. VARP
          37. WEIBULL
          38. ZTEST
      7. Context Library (PQL)
    3. Function Elements and Syntax
      1. Function Arguments
      2. Function Return Values
      3. Operators
        1. Arithmetic Operators
        2. Comparison Operators
        3. Logical Operators
      4. Data Object Syntax
        1. Dimensions and Tables
        2. Hierarchies and Columns
        3. Members and Elements
        4. Values and Measures
        5. Data Points or Tuples
        6. Lists and Sets
        7. SelfCalc
    4. Script Editors
      1. PQL Editor
  2. Extensibility
    1. Embedding
      1. Embed Flows
      2. Embed Authentication
      3. Embed Code Examples
      4. Embed Troubleshooting
      5. Embed API
        1. Embed API Objects
        2. PyramidEmbedClient
          1. Login
          2. LoginWindowsAuth
          3. LoginSamlAuth
          4. LoginOpenIdAuth
          5. Authentication Failure Callback
          6. Init
          7. Embed
          8. Hub
          9. QuickEmbed
          10. SetAuthToken
          11. GetAuthToken
          12. Host
          13. IsClientLoaded
          14. IsLoggedIn
          15. Content Embedding
            1. EmbedOptions
              1. QuickEmbedOptions
              2. Export Types
            2. Filter
              1. Add (filters)
              2. AddUniqueName (filters)
            3. Target
              1. Add (targets)
            4. EmbeddedResult
              1. GoToSlide
              2. EmbeddedType
              3. Query
              4. Hierarchy
              5. Member
          16. Hub Embedding
            1. Hub (Object)
              1. HubEmbedOptions
                1. Style
      6. Raw API (Embed API v1.0)
        1. Using Raw API
        2. Raw Code Embedding
    2. Direct Load (via URL)
      1. URL Parameterization
    3. External Parameterization
      1. Target Parameterization for Presentations
    4. Direct Launch (via URL)
  3. APIs
    1. Main API and SDKs
      1. Using REST
      2. Using SDKs
      3. REST API HTTP Status Codes
      4. Authentication APIs Overview
      5. API 3.0 Methods
        1. Access APIs
          1. addAnalystProfile
          2. addDomainSettings
          3. addProProfile
          4. addScientistProfile
          5. addUserToRole
          6. addUsersToRole
          7. addViewerProfile
          8. changeRoleAdGroups
          9. changeUserLicense
          10. createRole
          11. createRoles
          12. createTenant
          13. createTenants
          14. createUserAd
          15. createUserDb
          16. createUserOpenId
          17. createUserSaml
          18. createUsersAd
          19. createUsersDb
          20. createUsersOpenId
          21. createUsersSaml
          22. deleteProfile
          23. deleteRole
          24. deleteTenants
          25. deleteUser
          26. findRoles
          27. getAllAnalystProfiles
          28. getAllProfessionalProfiles
          29. getAllRoles
          30. getAllScientistProfiles
          31. getAllTenants
          32. getAllViewerProfiles
          33. getDefaultTenant
          34. getGroupsByRole
          35. getLicenseCount
          36. getLicenseExpirationDate
          37. getLicenseValidationStatus
          38. getMe
          39. getProfileForUser
          40. getPublicRoles
          41. getPublicRolesByTenant
          42. getRoleById
          43. getRolesByUser
          44. getRolesbyProfile
          45. getTenantByName
          46. getTenantUnusedLicenseCount
          47. getTenantUsersByUserType
          48. getUser
          49. getUserByOpenIdPrincipalName
          50. getUserBySamlPrincipalName
          51. getUserLastLogin
          52. getUserStatusById
          53. getUserStatusByName
          54. getUsersByCurrentTenant
          55. getUsersByName
          56. getUsersByRole
          57. getUsersByTenant
          58. searchAdGroups
          59. searchAdGroupsForUser
          60. searchAdUsers
          61. searchAdUsersForGroups
          62. setUserAdministrationLevel
          63. toggleUserStatus
          64. updateDomainAdminPermissions
          65. updateRoleProfiles
          66. updateTenant
          67. updateTenantSeats
          68. updateUserAd
          69. updateUserDb
          70. updateUserOpenId
          71. updateUserRoles
          72. updateUserSaml
          73. updateUsersAd
          74. updateUsersDb
          75. updateUsersOpenId
          76. updateUsersPhones
          77. updateUsersSaml
        2. Analytics APIs
          1. createDiscover
          2. extractNlpQueryResult
          3. extractQueryResult
          4. getFormula
          5. getList
          6. getParameterElements
          7. setFormula
          8. setList
        3. Authentication APIs
          1. authenticateUser
          2. authenticateUserByToken
          3. authenticateUserEmbed
          4. authenticateUserEmbedByToken
          5. authenticateUserEmbedOPENID
          6. authenticateUserEmbedSAML
          7. authenticateUserEmbedWindows
          8. authenticateUserOPENID
          9. authenticateUserSAML
          10. authenticateUserWindows
        4. Content APIs
          1. addItemsToFavorites
          2. addRoleToItem
          3. addTag
          4. addTagToItem
          5. changeItemDescription
          6. changeItemFolder
          7. copyItems
          8. createNewFolder
          9. deleteItems
          10. deleteTag
          11. exportContent
          12. exportHub
          13. findContentItem
          14. findHub
          15. findItemsByTag
          16. findItemsByTagName
          17. getAllItemTags
          18. getAllItemsCreatedByUser
          19. getAllTags
          20. getAllTagsData
          21. getAutoRecommendedItems
          22. getContentItemMetaData
          23. getFavoriteItems
          24. getFolderItems
          25. getItem
          26. getItemRoles
          27. getItemRolesID
          28. getMostUsedItems
          29. getPrivateFolderForUser
          30. getRecentItems
          31. getRecommendedItems
          32. getTagData
          33. getTenantPublicOrGroupFolder
          34. getUserGroupFolders
          35. getUserGroupRootFolder
          36. getUserPrivateFolder
          37. getUserPrivateRootFolder
          38. getUserPublicFolders
          39. getUserPublicRootFolder
          40. importContent
          41. importHub
          42. moveItems
          43. purgeContentItems
          44. removeItemsFromFavorites
          45. removeRolesFromItem
          46. removeTagFromItem
          47. renameItem
          48. restoreDeletedItems
        5. Datasources APIs
          1. addHierarchyOverlay
          2. addHierarchySecurity
          3. addMeasureOverlay
          4. addMeasureSecurity
          5. addMembersSecurity
          6. addRolesToDataBase
          7. addRolesToItemAndBubbleUp
          8. addRolesToItemAndPropagate
          9. addRolesToModel
          10. addRolesToServer
          11. changeDataSource
          12. changeDataSources
          13. createDataServer
          14. createDataServers
          15. deleteDataBase
          16. deleteDataSource
          17. deleteHierarchyOverlay
          18. deleteHierarchySecurity
          19. deleteMaterializedModel
          20. deleteMeasureOverlay
          21. deleteMeasureSecurity
          22. deleteMembersSecurity
          23. deleteRolesFromDatabase
          24. deleteRolesFromModel
          25. deleteRolesFromServer
          26. executeMasterFlow
          27. exportDataCatalog
          28. exportModel
          29. findDatabaseByName
          30. findModelConnection
          31. findServerByName
          32. getAllConnectionStrings
          33. getDataServerDetails
          34. getDataSourcesByTenant
          35. getDataSourcesByUserId
          36. getDatasourceUsedTables
          37. getHierarchyOverlay
          38. getHierarchySecurity
          39. getItemConnectionString
          40. getMasterFlowProgressUpdate
          41. getMasterFlowVariables
          42. getMeasureOverlay
          43. getMeasureSecurity
          44. getMemberSecurity
          45. getModelStructure
          46. getPulseNodesForTenant
          47. getRolesByDataBase
          48. getRolesByModel
          49. getRolesByServer
          50. getSourceByNode
          51. getTargetByNode
          52. getUserDataCatalog
          53. importModel
          54. recognizeDataBase
          55. recognizeModel
          56. updateDataCatalog
          57. updateDataFlowNodeSchemas
          58. updateModelName
          59. updateModelProcessDate
          60. updateSourceNodeConnection
          61. updateTargetNodeConnection
          62. updateVariableConnection
          63. updateVariableValue
          64. validateMasterFlow
        6. Notification APIs
          1. getNotificationIndicators
        7. Tasks APIs
          1. deleteSchedule
          2. deleteSchedules
          3. findSchedule
          4. getExecutions
          5. getScheduleExecutionStatus
          6. getSchedulesForUser
          7. getTaskData
          8. getTaskOutputs
          9. getTaskOutputsForUser
          10. getTasks
          11. getTasksIds
          12. reRunTask
          13. resumeSchedule
          14. runOnDemandSchedules
          15. runSchedule
          16. suspendSchedule
        8. Themes APIs
          1. applyTheme
          2. exportTheme
          3. findThemeByName
          4. importTheme
      6. API 2.0 Methods
        1. Access APIs
          1. addAnalystProfile
          2. addDomainSettings
          3. addProProfile
          4. addProfile
          5. addScientistProfile
          6. addUserToRole
          7. addUsersToRole
          8. addViewerProfile
          9. changeLicenseForUser
          10. changeRoleAdGroupMembership
          11. createRole
          12. createRoles
          13. createTenant
          14. createTenants
          15. createUserAd
          16. createUserDb
          17. createUserOpenId
          18. createUserSaml
          19. createUsersAd
          20. createUsersDb
          21. createUsersOpenId
          22. createUsersSaml
          23. deleteProfile
          24. deleteRole
          25. deleteTenants
          26. deleteUser
          27. getAllNonPrivateRoles
          28. getAllNonPrivateRolesByTenant
          29. getAllNonPrivateRolesIDByTenant
          30. getAllProfiles
          31. getAllProfilesByClientLicenseType
          32. getAllProfilesByClientLicenseTypeByTenantId
          33. getAllProfilesByTenantId
          34. getAllRoles
          35. getAllRolesByProfileId
          36. getAllRolesByUser
          37. getAllTenants
          38. getAllUsersByCurrentTenant
          39. getAllUsersByTenant
          40. getAllUsersDataByTenantAndLicenceType
          41. getAvailableTenantLicenseCount
          42. getDefaultTenant
          43. getGroupsByRole
          44. getLicenseCount
          45. getLicenseCount2
          46. getLicenseExpirationDate
          47. getLicenseValidationStatus
          48. getMe
          49. getPrivateProfileIdForUser
          50. getRoleById
          51. getRolesByName
          52. getTenantByName
          53. getUser
          54. getUserByOpenIdPrincipalName
          55. getUserBySamlPrincipalName
          56. getUserLastLogin
          57. getUserStatusById
          58. getUserStatusByName
          59. getUsersByName
          60. getUsersByRole
          61. searchAdGroups
          62. searchAdGroupsForUser
          63. searchAdUsers
          64. searchAdUsersForGroups
          65. setUserAdministrationLevel
          66. toggleEnableUser
          67. updateDomainAdminPermissions
          68. updateRolesByProfileId
          69. updateTenant
          70. updateTenantSeats
          71. updateUserAd
          72. updateUserDb
          73. updateUserOpenId
          74. updateUserRoles
          75. updateUserSaml
          76. updateUsersAd
          77. updateUsersDb
          78. updateUsersOpenId
          79. updateUsersPhones
          80. updateUsersSaml
        2. Auth APIs
          1. authenticateUser
          2. authenticateUserByToken
          3. authenticateUserEmbed
          4. authenticateUserEmbedByToken
          5. authenticateUserEmbedOPENID
          6. authenticateUserEmbedSAML
          7. authenticateUserEmbedWindows
          8. authenticateUserOPENID
          9. authenticateUserOPENIDAlt
          10. authenticateUserSAML
          11. authenticateUserSAMLAlt
          12. authenticateUserWindows
        3. Content APIs
          1. addContentItemsToFavorites
          2. addRoleToItem
          3. addTag
          4. addTagToItem
          5. changeItemDescription
          6. changeItemFolder
          7. copyItems
          8. createNewFolder
          9. deleteTag
          10. exportContent
          11. exportContent2
          12. exportHub
          13. findContentItem
          14. findItemsByTagId
          15. findItemsByTagName
          16. getAllItemTags
          17. getAllItemsCreatedByUser
          18. getAllTags
          19. getAllTagsData
          20. getAllUserContentItems
          21. getAutoRecommendedItems
          22. getContentItemMetaData
          23. getContentItemSecurityRoles
          24. getContentItemSecurityRolesID
          25. getFavoriteItems
          26. getFolderItems
          27. getItem
          28. getMostUsedItems
          29. getPrivateFolderForUser
          30. getPrivateRootFolder
          31. getPublicOrGroupFolderByTenantId
          32. getRecentItems
          33. getRecommendedItems
          34. getTag
          35. getUserGroupFolders
          36. getUserGroupRootFolder
          37. getUserPrivateFolder
          38. getUserPrivateRootFolder
          39. getUserPublicFolders
          40. getUserPublicRootFolder
          41. importContent
          42. importHub
          43. moveItems
          44. purgeContentItems
          45. removeContentItemsFromFavorites
          46. removeRolesFromItem
          47. removeTagFromItem
          48. renameItem
          49. restoreSoftDeletedContentItems
          50. softDeleteContentItems
        4. Datasources APIs
          1. addHierarchyOverlayToModel
          2. addHierarchySecurityToModel
          3. addMeasureOverlayToModel
          4. addMeasureSecurityToModel
          5. addMembersSecurityToModel
          6. addRolesToDataBase
          7. addRolesToItemAndBubbleUp
          8. addRolesToItemAndPropagate
          9. addRolesToModel
          10. addRolesToServer
          11. changeDataSource
          12. changeDataSources
          13. createDataServer
          14. createDataServers
          15. deleteDataBase
          16. deleteDataSource
          17. deleteHierarchyOverlayFromModel
          18. deleteHierarchySecurityFromModel
          19. deleteMaterializedModel
          20. deleteMeasureOverlayFromModel
          21. deleteMeasureSecurityFromModel
          22. deleteMembersSecurityFromModel
          23. deleteRolesFromDatabase
          24. deleteRolesFromModel
          25. deleteRolesFromServer
          26. executeMasterFlow
          27. exportMaterializedModelDataCatalog
          28. exportModel
          29. findDatabaseByName
          30. findModelByName
          31. findServerByName
          32. getAllConnectionStrings
          33. getDataModelStructure
          34. getDataSourcesByTenant
          35. getDataSourcesByUserId
          36. getDatasourceUsedTables
          37. getHierarchySecurity
          38. getItemConnectionString
          39. getMasterFlowProgressUpdate
          40. getMasterFlowVariables
          41. getMeasureSecurity
          42. getMemberSecurity
          43. getModelHierarchyOverlay
          44. getModelMeasureOverlay
          45. getPulseNodesForTenant
          46. getRolesByDataBase
          47. getRolesByModel
          48. getRolesByServer
          49. getServerDataById
          50. getSourceByNodeId
          51. getTargetByNodeId
          52. getUserDataCatalog
          53. importMaterializedModelDataCatalog
          54. importModel
          55. recognizeDataBase
          56. recognizeModel
          57. searchConnectionString
          58. updateDataFlowNodeSchemas
          59. updateModelName
          60. updateModelProcessDate
          61. updateSourceNodeConnection
          62. updateTargetNodeConnection
          63. updateVariableConnection
          64. updateVariableValue
          65. validateMasterFlow
        5. Notification APIs
          1. getNotificationIndicators
        6. Query APIs
          1. extractNlpQueryResult
          2. extractQueryResult
          3. getParameterElements
        7. Tasks APIs
          1. deleteSchedule
          2. findSchedule
          3. getExecutions
          4. getScheduleExecutionStatus
          5. getSchedulesForUser
          6. getTaskData
          7. getTaskOutputs
          8. getTaskOutputsForUser
          9. getTasks
          10. getTasksIds
          11. reRunTask
          12. resumeSchedule
          13. runOnDemandSchedules
          14. runSchedule
          15. suspendSchedule
        8. Themes APIs
          1. applyTheme
          2. exportTheme
          3. findThemeByName
          4. importTheme
      7. API Objects and Enumerations
        1. API Object Definitions
          1. AccessType
          2. AddHierarchyOverlayApiObject
          3. AddMeasureOverlayApiObject
          4. AddUserRoleData
          5. AddUsersRoleData
          6. AdditionalServerProperties
          7. AdminMultiTenantData
          8. AdminType
          9. AdminTypeApiData
          10. AggregationType
          11. AnalystPermissionOptions
          12. AnalystProfileApiData
          13. AnalyticsPermissions
          14. ApiResponseFormat
          15. ApiResultLicenseStatus
          16. ApiResultTaskStatus
          17. AttributeTranslation
          18. AxisTotalsType
          19. BaseUserOpenIdCredentials
          20. BaseUserSamlCredentials
          21. BulkWritingType
          22. BwDatabaseListType
          23. BwInfoAreaTreeViewType
          24. CartesianBarVisualType
          25. CartesianCategoriesDropZone
          26. CartesianCategoriesHierarchyChip
          27. CartesianColorChip
          28. CartesianColorDropZone
          29. CartesianColorHierarchyChip
          30. CartesianColorMeasureChip
          31. CartesianColumnVisualType
          32. CartesianFilterChip
          33. CartesianFilterDropZone
          34. CartesianFilterHierarchyChip
          35. CartesianFilterValuesChip
          36. CartesianLabelsChip
          37. CartesianLabelsDropZone
          38. CartesianLabelsHierarchyChip
          39. CartesianLabelsMeasureChip
          40. CartesianLineVisualType
          41. CartesianMotionDropZone
          42. CartesianMotionHierarchyChip
          43. CartesianShapeChip
          44. CartesianShapeDropZone
          45. CartesianShapeHierarchyChip
          46. CartesianShapeMeasureChip
          47. CartesianSizeDropZone
          48. CartesianSizeMeasureChip
          49. CartesianStackedBarVisualType
          50. CartesianStackedColumnVisualType
          51. CartesianTooltipChip
          52. CartesianTooltipDropZone
          53. CartesianTooltipHierarchyChip
          54. CartesianTooltipMeasureChip
          55. CartesianTrellisHorizontalChip
          56. CartesianTrellisHorizontalDropZone
          57. CartesianTrellisHorizontalHierarchyChip
          58. CartesianTrellisHorizontalValuesChip
          59. CartesianTrellisVerticalChip
          60. CartesianTrellisVerticalDropZone
          61. CartesianTrellisVerticalHierarchyChip
          62. CartesianTrellisVerticalValuesChip
          63. CartesianValuesDropZone
          64. CartesianValuesMeasureChip
          65. CartesianValuesVisualTypes
          66. CartesianVisual
          67. CartesianVisualType
          68. ChangeItemDescriptionData
          69. ChangeUserLicenseObject
          70. ClashDefaultOption
          71. ClientLicenseType
          72. ColorMathFunction
          73. ConditionConjunctionType
          74. ConnStringDscApiObject
          75. ConnectedItemsSearchCriteria
          76. ConnectionSearchCriteria
          77. ConnectionStringData
          78. ConnectionStringProperties
          79. ConnectionStringType
          80. ContentItemObject
          81. ContentSearchParamsObject
          82. ContentType
          83. ContentTypeObject
          84. CreateUserAdObject
          85. CreateUserDbObject
          86. CreateUserOpenIdObject
          87. CreateUserSamlObject
          88. CreatedThemeResult
          89. CsvDelimiter
          90. CubeAuthMethod
          91. CustomRootCAType
          92. DataBaseRecognitionObject
          93. DataCatalogDimension
          94. DataCatalogHierarchy
          95. DataCatalogHierarchyLevel
          96. DataCatalogItem
          97. DataCatalogMeasure
          98. DataCatalogModelMetadata
          99. DataCatalogProperty
          100. DataCatalogUpdateData
          101. DataFlowModelType
          102. DataSourceTableResult
          103. DataSourceUsedTablesResult
          104. DataType
          105. DeleteHierarchyOverlayApiObject
          106. DeleteMeasureOverlayApiObject
          107. DeleteTenantApiData
          108. DiscoverData
          109. DiscoverDataCatalog
          110. DomainAdminPermissionAPIObject
          111. DomainAdminPermissionType
          112. DomainAdminPermissions
          113. DomainSecurityObject
          114. DscApiData
          115. ElementSelectionData
          116. ElementSelectionDataType
          117. EnumerationOutput
          118. ErrorMessage
          119. EtlSyncModelColumnsType
          120. ExecuteMasterFlowObject
          121. ExecuteMasterFlowResult
          122. ExecuteScheduleApiData
          123. ExecutionSettings
          124. ExecutionViewData
          125. ExportContentApiData
          126. ExportData
          127. ExportOptions
          128. ExternalParameters
          129. FilterHierarchyType
          130. FilterParameter
          131. FilterValuesType
          132. FirstWorkday
          133. FolderTenantObject
          134. FormulaData
          135. FtpDataMode
          136. FtpSecurityType
          137. FtpSettings
          138. GaType
          139. GetItemParamsObject
          140. GetOverlaySecurityObject
          141. GridColorChip
          142. GridColorDropZone
          143. GridColorHierarchyChip
          144. GridColorMeasureChip
          145. GridColorOption
          146. GridColsChip
          147. GridColsDropZone
          148. GridColsHierarchyChip
          149. GridColsValuesChip
          150. GridFilterChip
          151. GridFilterDropZone
          152. GridFilterHierarchyChip
          153. GridFilterValuesChip
          154. GridIndicatorDropZone
          155. GridIndicatorMeasureChip
          156. GridRowsChip
          157. GridRowsDropZone
          158. GridRowsHierarchyChip
          159. GridRowsValuesChip
          160. GridSizeDropZone
          161. GridSizeMeasureChip
          162. GridTooltipChip
          163. GridTooltipDropZone
          164. GridTooltipHierarchyChip
          165. GridTooltipMeasureChip
          166. GridValuesDropZone
          167. GridValuesMeasureChip
          168. GridVisual
          169. HideMemberType
          170. HierarchyCategory
          171. HierarchyElementSelection
          172. HierarchyMeasureSecurity
          173. HierarchyMeasureSecurityApiObject
          174. HierarchyOverlayData
          175. HierarchyOverlayProperty
          176. HierarchyOverlayToDeleteData
          177. HierarchyType
          178. HubApiObject
          179. ImportApiResultObject
          180. ImportMaterializedModelObject
          181. IsolationMode
          182. ItemId
          183. ItemParentApiData
          184. ItemRolePair
          185. ItemRolesForRemoval
          186. ItemRolesToBeAdded
          187. ItemType
          188. ItemsForFavorites
          189. ItemsToCopy
          190. ItemsToMove
          191. JoinType
          192. KpiAttributeType
          193. LanguageType
          194. LdapGroupDetails
          195. LdapGroupIdentifier
          196. LdapSearchObject
          197. LdapSearchType
          198. LdapUserObject
          199. LdapUsersSearchObject
          200. LicenseCountObject
          201. LicenseStatus
          202. ListData
          203. MSOlapProperties
          204. MapColorChip
          205. MapColorDropZone
          206. MapColorHierarchyChip
          207. MapColorMeasureChip
          208. MapDetailsDropZone
          209. MapDetailsHierarchyChip
          210. MapFilterDropZone
          211. MapFilterHierarchyChip
          212. MapLocationChip
          213. MapLocationDropZone
          214. MapLocationHierarchyChip
          215. MapLocationMeasureChip
          216. MapMotionDropZone
          217. MapMotionHierarchyChip
          218. MapSizeDropZone
          219. MapSizeMeasureChip
          220. MapTooltipChip
          221. MapTooltipDropZone
          222. MapTooltipHierarchyChip
          223. MapTooltipMeasureChip
          224. MapVisual
          225. MapVisualType
          226. MaskingMethodType
          227. MasterFlowFindDataSourceObject
          228. MasterFlowModelNameObject
          229. MasterFlowOtherObject
          230. MasterFlowProgressResult
          231. MasterFlowSchemasObject
          232. MasterFlowSourceConnectionObject
          233. MasterFlowSourceObject
          234. MasterFlowTargetConnectionObject
          235. MasterFlowTargetObject
          236. MasterFlowUpdatedVariableResult
          237. MasterFlowValidationResult
          238. MasterFlowVariableConnectionObject
          239. MasterFlowVariableObject
          240. MasterFlowVariableValueObject
          241. MasterFlowVariablesResult
          242. MasterFlowVariablesValueObject
          243. MaterializedApiObject
          244. MaterializedItemObject
          245. MaterializedItemType
          246. MeasureFormat
          247. MeasureGroup
          248. MeasureMapOptions
          249. MeasureOverlayData
          250. MeasureOverlayProperty
          251. MeasureOverlayToDeleteData
          252. MemberDataApi
          253. MembersSecurity
          254. MembersSecurityApiObject
          255. MetaDataTranslation
          256. ModelAttributeType
          257. ModelDataCatalog
          258. ModelDataFlowSourceInfo
          259. ModelProcessDateObject
          260. ModelProcessDateResult
          261. ModelRecognitionObject
          262. ModelScheduleOnDemandObject
          263. ModelScheduleOnDemandResult
          264. ModelSyncColumnsSettings
          265. ModelingAggregationMapping
          266. ModelingColumn
          267. ModelingColumnCategories
          268. ModelingColumnType
          269. ModelingConfigTranslation
          270. ModelingFolderTranslations
          271. ModelingHierarchy
          272. ModelingHierarchyLevel
          273. ModelingMeasure
          274. ModelingModel
          275. ModelingProperty
          276. ModelingRelationship
          277. ModelingRelationshipColumnPair
          278. ModelingServerInfo
          279. ModelingTable
          280. ModelingTableType
          281. ModelingTranslation
          282. ModifiedItemsResult
          283. MsOlapConnectionType
          284. NewFolderApiData
          285. NlpQueryExportData
          286. NotificationIndicatorsResult
          287. OauthDataSourceSettings
          288. OdbcDirectQueryOptions
          289. OpenIdAuthType
          290. OperatorType
          291. PaperType
          292. ParentChildOrphans
          293. ParentChildRollupType
          294. PermissionBitIndex
          295. PieApiObject
          296. PrintingOutputType
          297. ProPermissionOptions
          298. ProPermissions
          299. ProProfileApiData
          300. ProfileApiData
          301. ProfilePermissionHolder
          302. ProfileRolesData
          303. PulseClientData
          304. PyramidContentItem
          305. PyramidItemIdentifier
          306. PyramidViewUserObject
          307. QueryCacheMode
          308. QueryExportData
          309. QueryOptions
          310. QueryTotalPosition
          311. QueryTotalSettings
          312. RelatedItemData
          313. RenameItemApiData
          314. RoleAdGroupsModifyObject
          315. RoleAssignment
          316. RoleAssignmentType
          317. RoleData
          318. RoleMinimalData
          319. RoleToItemApiData
          320. RolesInItemRemovalObject
          321. RootFolderType
          322. SapBwServerConnectionType
          323. ScatterColorChip
          324. ScatterColorDropZone
          325. ScatterColorHierarchyChip
          326. ScatterColorMeasureChip
          327. ScatterDetailsDropZone
          328. ScatterDetailsHierarchyChip
          329. ScatterFilterChip
          330. ScatterFilterDropZone
          331. ScatterFilterHierarchyChip
          332. ScatterFilterValuesChip
          333. ScatterLabelsChip
          334. ScatterLabelsDropZone
          335. ScatterLabelsHierarchyChip
          336. ScatterLabelsMeasureChip
          337. ScatterMotionDropZone
          338. ScatterMotionHierarchyChip
          339. ScatterShapeChip
          340. ScatterShapeDropZone
          341. ScatterShapeHierarchyChip
          342. ScatterShapeMeasureChip
          343. ScatterSizeDropZone
          344. ScatterSizeMeasureChip
          345. ScatterTooltipChip
          346. ScatterTooltipDropZone
          347. ScatterTooltipHierarchyChip
          348. ScatterTooltipMeasureChip
          349. ScatterTrellisHorizontalChip
          350. ScatterTrellisHorizontalDropZone
          351. ScatterTrellisHorizontalHierarchyChip
          352. ScatterTrellisHorizontalValuesChip
          353. ScatterTrellisVerticalChip
          354. ScatterTrellisVerticalDropZone
          355. ScatterTrellisVerticalHierarchyChip
          356. ScatterTrellisVerticalValuesChip
          357. ScatterVisual
          358. ScatterVisualType
          359. ScatterXValuesDropZone
          360. ScatterXValuesMeasureChip
          361. ScatterYValuesDropZone
          362. ScatterYValuesMeasureChip
          363. ScheduleDataType
          364. ScheduleSearchCriteria
          365. ScheduleStatus
          366. ScheduleType
          367. ScheduleViewObject
          368. ScientistPermissionOptions
          369. ScientistPermissions
          370. ScientistProfileApiData
          371. SearchAdGroupUsersData
          372. SearchAdUserGroupsData
          373. SearchCriteria
          374. SearchMatchType
          375. SearchRootFolderType
          376. SecurityType
          377. SegmentColorChip
          378. SegmentColorDropZone
          379. SegmentColorHierarchyChip
          380. SegmentColorMeasureChip
          381. SegmentDetailsDropZone
          382. SegmentDetailsHierarchyChip
          383. SegmentFilterChip
          384. SegmentFilterDropZone
          385. SegmentFilterHierarchyChip
          386. SegmentFilterValuesChip
          387. SegmentLabelsChip
          388. SegmentLabelsDropZone
          389. SegmentLabelsHierarchyChip
          390. SegmentLabelsMeasureChip
          391. SegmentMotionDropZone
          392. SegmentMotionHierarchyChip
          393. SegmentSizeDropZone
          394. SegmentSizeMeasureChip
          395. SegmentTooltipChip
          396. SegmentTooltipDropZone
          397. SegmentTooltipHierarchyChip
          398. SegmentTooltipMeasureChip
          399. SegmentTrellisHorizontalChip
          400. SegmentTrellisHorizontalDropZone
          401. SegmentTrellisHorizontalHierarchyChip
          402. SegmentTrellisHorizontalValuesChip
          403. SegmentTrellisVerticalChip
          404. SegmentTrellisVerticalDropZone
          405. SegmentTrellisVerticalHierarchyChip
          406. SegmentTrellisVerticalValuesChip
          407. SegmentValuesDropZone
          408. SegmentValuesMeasureChip
          409. SegmentVisual
          410. SegmentVisualType
          411. ServerAuthenticationMethod
          412. ServerData
          413. ServerEffectiveUserName
          414. ServiceStatus
          415. SimpleModifierResult
          416. SizeDropZoneOptions
          417. SizeMathFunction
          418. SparkTransportMode
          419. SyntaxType
          420. TabularColorChip
          421. TabularColorDropZone
          422. TabularColorHierarchyChip
          423. TabularColorMeasureChip
          424. TabularColsChip
          425. TabularColsDropZone
          426. TabularColsHierarchyChip
          427. TabularColsMeasureChip
          428. TabularFilterDropZone
          429. TabularFilterHierarchyChip
          430. TabularSizeDropZone
          431. TabularSizeMeasureChip
          432. TabularTooltipChip
          433. TabularTooltipDropZone
          434. TabularTooltipHierarchyChip
          435. TabularTooltipMeasureChip
          436. TabularVisual
          437. TagData
          438. TagType
          439. TagUsageApiData
          440. TargetParameter
          441. TaskStatus
          442. TaskSummary
          443. TaskUserApiData
          444. TaskViewData
          445. TenantLicenseTypeData
          446. TenantObject
          447. TenantSettings
          448. TenantUsersGetObject
          449. ThemeApiObject
          450. ThemeListObject
          451. ThemeToItemsApiObject
          452. ToggleUserApiData
          453. TotalsSettings
          454. UpdateSchemaValidation
          455. UpdateTenantSeatsObject
          456. UpdateUserAdObject
          457. UpdateUserDbObject
          458. UpdateUserOpenIdObject
          459. UpdateUserSamlObject
          460. UserCredentials
          461. UserOpenIdCredentials
          462. UserPhone
          463. UserProfileType
          464. UserRolesData
          465. UserSamlCredentials
          466. UserStatus
          467. UserTokenCredentials
          468. ValidRootFolderType
          469. ValuesDropZoneOptions
          470. VariableType
          471. ViewerPermissionOptions
          472. ViewerPermissions
          473. ViewerProfileApiData
          474. Visuals
        2. API Enumeration Definitions
    2. Custom Visual API
      1. Custom Visual APIs 2.0
        1. Getting Started with the CV API
          1. Custom Visual Example - Aster Plot
        2. CvApi2
          1. Canvas
            1. Style
          2. ResultSet
            1. Data
              1. TrellisData
                1. Datapoint
                  1. Numerics
                    1. Value
            2. Dropzone
              1. Chip
                1. Element
          3. VisualConfig
          4. Utils
          5. ExternalLibraries
            1. D3Libraries
            2. UtilsLibraries
          6. Enums
            1. ChipType
            2. ColorRangeType
            3. DropZoneType
            4. Event
    3. Custom WorkFlow API
      1. Using the WorkFlow API
        1. Custom Workflow API Example
      2. Workflow API Overview
      3. WorkflowApi
        1. Canvas
        2. WorkflowThread
          1. Entry
            1. Attachment
          2. Contact
        3. Session
        4. Utilities
        5. ExternalLibraries
        6. Enums
          1. AttachmentType
          2. ContactType
          3. ThemeType
          4. WorkflowThreadType

Video Tutorials

  1. Pro Videos
    1. Model Videos
    2. Discover Videos
      1. Discover Visualization Videos
      2. Discover Analytics Videos
    3. Present Videos
    4. Publish Videos
    5. Formulate Videos
    6. Tabulate Tutorial Videos
    7. Illustrate Videos
    8. Content Manager Videos
    9. Admin Videos
  2. Analyst Videos
  3. Viewer Videos

Pyramid Analytics © 2017-2024